HELP PLOTTING

  • Thread starter Thread starter Raz
  • Start date Start date
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.
 
Replace the blanks by =NA() which will display as #N/A
These will be ignored by chart engine
best wishes
 
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
 
Back
Top