Multiple X-Axis

O

OkieViking

Excel is set up to plot one X-axis against two y-axis.
How do you plot one Y axis against multiple X-axis?
 
J

Jon Peltier

Make your chart with at least one series on the secondary axis, as
you've done. Right click on the chart, choose Chart Options, click on
the Axes tab. Uncheck the secondary Y axis and check the secondary X axis.

- Jon
 
O

OkieViking

Thanks Jon,

Can't believe I hadn't seen that before for as long as
I've been frustrated about it. But then again, none of my
collegues have either.... BTW: great web site!
-OkieViking
 

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

Similar Threads

Finding asymptote equation and how to draw them in excel 0
Scatter chart with categories on x-Axis 2
Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Comparative Scatterplot?? 1
simple chart 0
How do I extend the X-axis in Excel2007 3
A line chart 3

Top