secondary axis

  • Thread starter Thread starter Dave B
  • Start date Start date
D

Dave B

Hi,

I have a chart with two series of data, each has its own axis, one is on the
left and one on the right, both labeled, and I can click on either one to
change the scale, etc.

But when I try the same chart (one series on primary axis and one on
secondary axis) with "Categories in Reverse Order", I can't get the second
axis to appear. Has anyone ever had this problem? Thanks.

Dave
 
Dave -

Yep, this can be confusing. When the categories are in reverse order,
the primary Y axis goes where Excel wants to put the secondary one, and
there's a conflict. Whet I find helps is to right click on the chart,
choose Chart Options, and on the Axes tab, check the Secondary X axis
box too. With this visible, you can reverse its categories, and if
necessary impose a specific Axis Crosses At value to prevent the two Y
axes from blocking each other. It's hard to understand, hard to explain,
and hard to believe. You'll need to play a little bit to make it work
out. Or simply fix the order of the data in the worksheet.

- Jon
 
Back
Top