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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto selection of Data 1
How do I eliminate empty cells from plotting on chart 1
create blank/empty cell - don't want a zero to be plotted in chart 6
How do I stop chart from plotting null values as zeros in excel 20 3
Why function generated results are not plotting correctly? 1
Chart error: plotting series data XY scatter plot 3
Prevent non-numerical data (e.g. text) from plotting on a chart 1
need help with formula 3

Top