In an excel chart I want missing data to be ignored

S

stephenp

I have several graphs I want to generate from a table of data. Some of the
data is missing for certain parameters. Excel will not join points that are
not part of a continuous set of data

date Na conc. Cl conc
1/3/08 13 6
1/4/08 5
1/5/08 8
1/6/08 4 3

Any ideas
 
H

Heera

Hi,

If the cell is truly empty and the line drops to zero select the chart
and
check,
Tools > Options > Chart > Plot empty cells as...

If the cell actually contain conditional formula use NA() instead of
"" for
non data. This will interpolate the line but suppress the line marker.

Please check the link for more information.
http://www.andypope.info/charts.htm

Cheers
Heera
 

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

entering matching data for line charts 4
How do I get a chart to only display the dates in my table? 1
Pivot Chart- 2 unrelated series on 1 chart 4
Room Placement Grid 1
Combine 2 Charts 2007 Excel 1
Want previous years data to drop off as I enter current year data 3
X axis values on a line graph 1
Partially stacked column chart with 2 axis 4

Top