Two axises graph

  • Thread starter Thread starter Wujo
  • Start date Start date
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. :-(
 
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
 
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/
_______
 
Back
Top