HELP PLOTTING

R

Raz

was trying to plot two columns of data as below,
=SERIES(,'JAXXN Report'!$Q$14:$Q$73,'JAXXN Report'!$P$14:$P$73,1)

but I only have values in the first 10 rows. and rest of the cells have
equation to import values from other sheet. I think plot assuming all blank
cells as zeros.

How do I make the plot skip empty cells. But take them when values appear.
 
B

Bernard Liengme

Replace the blanks by =NA() which will display as #N/A
These will be ignored by chart engine
best wishes
 
A

Ashish Mathur

Hi,

you can also filter the range to exclude blank cells. Since the blank cells
will not be visible in the range, they will not be plotted at all.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Top