LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Maury Markowitz
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I "index" data in a line graph? ShirleyJL Charts and Charting in Excel 2 January 10th 05 10:06 PM
How do I add a reference line to Excel charts? roswellmike Charts and Charting in Excel 4 January 2nd 05 01:29 PM
How to force continuous lines in line charts wal50 Charts and Charting in Excel 1 December 21st 04 10:43 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Help with pivot charts and data labels [email protected] Charts and Charting in Excel 1 December 15th 04 03:08 PM


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"