HELP PLOTTING
 

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.

HELP PLOTTING
 

Replace the blanks by =NA() which will display as #N/A
These will be ignored by chart engine
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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

HELP PLOTTING
 

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

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