HELP PLOTTING

[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.

 

[Bernard Liengme]

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

 

[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