Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |