multiple scales for x axis?

  • Thread starter Thread starter ClarkT
  • Start date Start date
C

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?
 
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
 
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?
 
-----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
 
Back
Top