Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Line Chart with different beginning values

I have 3 series I am charting on a 2-d line chart. All series run for about
a year and a half but have different start and end dates. How do I get one
series to start on 10/1/05 and show that another series started on 5/1/05?
When I add the series that starts later, my chart adjusts and I lose the
detail of the 5/1 series.

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Line Chart with different beginning values

You could use an XY chart, which accepts independent X values for each
series. Or you could pad the beginning and end of each series with blanks to
stagger the series in the chart.

1 3
2 4
3 5
4 6 2
5 7 3
6 8 4
7 5
8 6
9 7

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DuaneS" wrote in message
...
I have 3 series I am charting on a 2-d line chart. All series run for
about
a year and a half but have different start and end dates. How do I get
one
series to start on 10/1/05 and show that another series started on 5/1/05?
When I add the series that starts later, my chart adjusts and I lose the
detail of the 5/1 series.

Thanks.



Reply
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
eliminate space at beginning of line Finger Tips Excel Worksheet Functions 1 June 1st 07 12:55 AM
Line chart even though values missing MattBeckwith Charts and Charting in Excel 1 January 17th 06 08:42 PM
Line chart zero values JC Charts and Charting in Excel 4 January 9th 06 12:57 AM
line chart with NA() values grime Charts and Charting in Excel 3 October 19th 05 01:56 PM
how to hide zero values on line chart MikeM Charts and Charting in Excel 2 October 7th 05 01:59 PM


All times are GMT +1. The time now is 11:59 PM.

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"