Secondary X axis possible?

J

Jon Peltier

Ken -

As long as you have two series in a chart, you can have primary and
secondary axes. To put a series onto the secondary axes, double click on
it, select the Axis tab, and select the Secondary option.

Usually Excel underestimates your intelligence, and sticks you with just
a secondary Y axis. But you can exercise your control over Excel in this
way. Right click the chart, and choose chart options. Click on the Axes
tab, and select the combination of primary and secondary X and Y axes
you want.

If you have all four axes in use, you cannot mix and match your series.
That is, if a series uses the primary X axis, it also must use the
primary Y axis.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top