How to check the condition before the chart is being plotted?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Parumuga - 21 Jan 2008 15:04 GMT

How to check the condition before the chart is being ploted?

For example:

I need to check the value in the cell “A1”. if the value in the cell A1 is
“1” , I need to plot the chart data that is present in the column B1 to
B2.If the value in the cell “A1” is “0”, then do not plot the chart.

How to do that.? Any ideas on this?

Reply to this Message

Bernard Liengme - 21 Jan 2008 15:16 GMT

=IF(A1=1,B1,NA())
or just
=IF(A1,B1,NA()) since Excel will take 1 as true and 0 as false
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> How to check the condition before the chart is being ploted?
>
[quoted text clipped - 6 lines]
>
> How to do that.? Any ideas on this?

Reply to this Message

Parumuga - 23 Jan 2008 01:28 GMT

Hi Bernard,

Thanks for your response. Where shall I use this formula?

I tried to use this formula in the sources data dialog box of the Chart, in
the Data range? But it is not allowing me saying, “Reference is not valid”.
Please provide me alternative solution or approach or suggestions?

Regards,

> =IF(A1=1,B1,NA())
> or just
[quoted text clipped - 11 lines]
> >
> > How to do that.? Any ideas on this?

Reply to this Message

Bernard Liengme - 23 Jan 2008 02:03 GMT

I assumed the B column held the y-values of you chart
Put the formula I gave in C or any other column and use it as the y-values.
Send me the file (to my private email , not to the newsgroup) and I will
return it with added formula
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi Bernard,
>
[quoted text clipped - 24 lines]
>> >
>> > How to do that.? Any ideas on this?

Reply to this Message