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.