Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter plot - Size of data points from spreadsheet value? | Charts and Charting in Excel | |||
Macro question | Excel Worksheet Functions | |||
labeling data points on a scatter chart | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Scatter Chart data | Charts and Charting in Excel |