Null points in a line chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a set of data which I wish to display as a line chart. The problem is,
the data contains both zero values and null values, and when I display the
chart, the null values 'revert to zero'. How can I avoid this? Is there a way
I can have some interpolated values between valid points rather than have the
null values display as zeroes? If not, I would settle for no point displayed
at all on the chart.

Any help gladly appreciated.
 

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

Blank Values in Excel Charts 7
Help with displaying formulas in charts 4
Vlookup finds a blank, but returns a zero - HELP! 6
How can I create a line chart with 800,000 data points 3
Omitting Zeros in a chart 2
Custom Number Format for text 8
null vs zero in regression analysis 2
Charts 5

Back
Top