Two axises graph

W

Wujo

My problem is to build the graph with two independend Y-axises, with 3 data
series.
How to define which axis belongs to the data serie?
There is predefined chart (with 2 axies), but when I add the 3rd serie, the
2nd axis get equal to the first. :-(
 
E

ehntd

When you do the graph options, rather than letting it automatically ad
your series do it yourself. Go to the Series tab and add them manuall
, then you can define which variables you want in your X or Y axis
 
J

Jon Peltier

To define which series is associated with a certain axis, double click on it, then
click on the Axis tab. Select Primary or Secondary. Note that at least one series
must remain on each axis to retain both sets of axes.

- 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

Similar Threads

Use text descriptors as Y axis units 1
Dynamic series in rows 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
Alternate axis at top of chart 1
Plotting Graph with dynamic table 3
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Change data Series from a bar to a line after changing axis 1
Overlay line graph points on bar graph 1

Top