If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|