Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Gappy data in line charts?
I have data series that may have gaps in them. For instance, this series is
typical: 1 yr 70 2 yr 87.5 3 yr 110 4 yr 120 5 yr 129 6 yr 7 yr 8 yr 9 yr 10 yr 162.5 For other series the gaps may appear in other places. I would like to chart all of these (up to five series) on a single chart. I can do this, but the gaps make the line "disappear" where there are gaps. For instance, in the case above there is a nice like from 1 to 6, then a single dot at 10. Is there some way to tell it to ignore the gap and draw straight lines over them? Maury |
#2
|
|||
|
|||
If you put "=NA()" into the blank cells, the gaps should go away.
"Maury Markowitz" wrote in message ... I have data series that may have gaps in them. For instance, this series is typical: 1 yr 70 2 yr 87.5 3 yr 110 4 yr 120 5 yr 129 6 yr 7 yr 8 yr 9 yr 10 yr 162.5 For other series the gaps may appear in other places. I would like to chart all of these (up to five series) on a single chart. I can do this, but the gaps make the line "disappear" where there are gaps. For instance, in the case above there is a nice like from 1 to 6, then a single dot at 10. Is there some way to tell it to ignore the gap and draw straight lines over them? Maury |
#3
|
|||
|
|||
Click on your chart then click on the Tools menu, choose Options and
select Interpolated for the plotting of zero values under the Chart section of the Options window. Andrea Jones www.stratatraining.co.uk Maury Markowitz wrote: I have data series that may have gaps in them. For instance, this series is typical: 1 yr 70 2 yr 87.5 3 yr 110 4 yr 120 5 yr 129 6 yr 7 yr 8 yr 9 yr 10 yr 162.5 For other series the gaps may appear in other places. I would like to chart all of these (up to five series) on a single chart. I can do this, but the gaps make the line "disappear" where there are gaps. For instance, in the case above there is a nice like from 1 to 6, then a single dot at 10. Is there some way to tell it to ignore the gap and draw straight lines over them? Maury |
#4
|
|||
|
|||
"Barb Reinhardt" wrote:
If you put "=NA()" into the blank cells, the gaps should go away. Thanks, works like a champ! Maury |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "index" data in a line graph? | Charts and Charting in Excel | |||
How do I add a reference line to Excel charts? | Charts and Charting in Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Help with pivot charts and data labels | Charts and Charting in Excel |