switching x axis
 

Some of the data from my worksheet is plotted on the 1st Y axis, some on the
second (as I want it to be). But the X axis appearing on my chart uses the
dates from the 1st X axis. How do I get it to rather use dates from the 2nd
X axis?

switching x axis
 

Assuming the chart has both primary axes and both secondary axes. If a
series is plotted on the primary axis, it has to use both primary axes. If
it's plotted on the secondary axis, it has to use both secondary axes. A
series cannot use one primary and one secondary axis.

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


"jonny" wrote in message
...
Some of the data from my worksheet is plotted on the 1st Y axis, some on
the
second (as I want it to be). But the X axis appearing on my chart uses the
dates from the 1st X axis. How do I get it to rather use dates from the
2nd
X axis?