Charting question

[bob]

I have two comlumns of numbers that I am plotting on an x-y chart. The Y
axis column is calculated like this.....
IF(B2,C3/A1,"")
so that if no number is entered into B2 then nothing is displayed in the
cell. The trouble is that when I define the series in the chart it plots
correctly up to the last calculated number but then the line dives down to
zero making the chart look stupid.

How can I get the line on the chart to stop at the last calculated number?
I don't want to have to enter numbers in the spreadsheet then "Fill Down" in
order to advance the line (which I'm doing now).

Randy

 

[bob]

Thanks Andy, that worked for the chart, but now the table is messy, but I'll
take the lesser or two evils.
Randy

 

[Andy Pope]

Hi bob,

Modify your formula to use NA().

=IF(B2,C3/A1,NA())

Cheers
Andy

 

[Andy Pope]

You can always use conditional formatting to set the font colour to the
cell background colour if the cell displays NA()

Thanks Andy, that worked for the chart, but now the table is messy, but I'll
take the lesser or two evils.
Randy

Hi bob,

Modify your formula to use NA().

=IF(B2,C3/A1,NA())

Cheers
Andy

bob wrote:


Y

plots

to

number?

Down" in