Problem with the display of a 2 axis chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a chart with 3 series, where 1 of the series is on the second axis.

The first series on the primary axis is a "full" series which are from startdate to enddate.
The second series on the primary axis is a series which starts "later" than the first series.
The series on the secondary axis have the same startdate and enddate as the second series on the primary axis.

My problem is that the series on the secondary axis "suddenly" stops a year before the actual enddate of the series (actually enddate of all the series). The second series on the primary axis goes all the way to the enddate. I have tried to set the X axis values to both the same as the primary X axis and also to the dates that corresponds to the series.

If I choose to put the series on the secondary axis to the primary axis, it goes all the way to the end.

Anyone know what i have overseen or doing wrong?
 
Peter -

What kind of chart is it? If ti's a line chart, you often have better
results if you select as large a range for the shorter series, including
blank cells where the longer series has values. If your series are like
this:

A B C
1 1
2 2
3 3 1 2
4 4 2 1
5 5 3 4
6 6 4 3

select the range for series B and C that includes the blank cells at the
top, so they are as long as series A.

The other thing to check is whether Excel may have given you a secondary
X axis as well as a secondary Y axis. Usually it doesn't if the chart
types are the same. If this has happened, you can delete the extra X
axis, and all series will use the primary one: Right click the chart,
choose Chart Options, click on the Axes tab, and uncheck the Secondary
Category Axis option.

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