Charting question

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

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" wrote in message
...
Hi bob,

Modify your formula to use NA().

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

Cheers
Andy

bob wrote:

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



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi bob,

Modify your formula to use NA().

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

Cheers
Andy

bob wrote:

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



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

bob wrote:

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" wrote in message
...

Hi bob,

Modify your formula to use NA().

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

Cheers
Andy

bob wrote:


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



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info