On Mar 9, 12:42 pm, "Jon Peltier"
wrote:
Yes, you can switch them, but you'll have to temporarily introduce the
secondary X axis (which Excel doesn't add by default).

Go to Chart menu Chart Options Axes tab, check the same option of
Secondary Category (X) Axis that is checked for Primary Category (X) Axis.

Double click the primary X axis (bottom of the chart) and on the Scale tab,
check Value (Y) Axis Crosses at Maximum Category.

Double click the secondary X axis (top of the chart) and on the Scale tab,
UN-check Value (Y) Axis Crosses at Maximum Category.

Go to Chart menu Chart Options Axes tab, UN-check the option of
Secondary Category (X) Axis that you selected above.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutionshttp://PeltierTech.com
_______

This worked well; thank you. But the gridlines are still aligned with
what used to be the primary Y axis (and is now the secondary Y axis).
How can I get the gridlines to line up with the new primary axis?
Thanks.