How do I chart missing data points in a scatter graph?
I'm trying to generate a scatter line graph that occasionally has data points
with no value. Instead of treating these as zero or interpolating the missing data, is there a way to have the chart stop the line until there is an associated value? Ideally, it would look something like this: *---* *-----* Thanks. |
How do I chart missing data points in a scatter graph?
I figured it out, seconds later. I went Tools - Options - Chart
I then clicked "Not Plotted (Leave Gaps)" ROCK! |
How do I chart missing data points in a scatter graph?
Alternatively, enter =NA() in the blank cells
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mickey" wrote in message ... I figured it out, seconds later. I went Tools - Options - Chart I then clicked "Not Plotted (Leave Gaps)" ROCK! |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com