multiple scales for x axis?

[ClarkT]

I'm making a line chart. I've got a data set that
references a values on the y axis. I need each series
(10) to have it's own scale on the x axis. I know this
can be done, but I can't seem to find where to start.
Help?

 

[Jon Peltier]

Make the chart with both series. Double click on one, and on the Axis
tab, select Secondary. That only gives you a secondary Y axis. Now right
click on the chart, select Chart Options from the pop up menu, and on
the Axes tab, check the Secondary X Axis box, and if you don't need the
Secondary Y axis, uncheck its box.

- Jon

 

[ClarkT]

Thanks, that's got me part of the way there. Now is it
possible for me to set up tertiary (sp?) and 4,5 or 6
series in the X axis?

 

[Bob Sullivan]

-----Original Message-----
I'm making a line chart. I've got a data set that
references a values on the y axis. I need each series
(10) to have it's own scale on the x axis. I know this
can be done, but I can't seem to find where to start.
Help?
.

What version of Excel are you using? It sounds to me as
though you can accomplish your goal with a Pivot Chart
report. Place your y axis data on the pivot chart, and
then use the page feature to create various alternative x
axes.

Bob Sullivan

 

[Jon Peltier]

I have an example on my web site showing how to make a tertiary Y axis:

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

Seems to me if you need more than this, it's going to get cluttered. You
might try to scale the axes, say, from 0 to 100% or some other
meaningful endpoints, and scale the X and Y data of the series accordingly.

- Jon