In Excel how do I label the axis of a chart with 2 sets of labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to put two labels on a chart say a time function together with a
quantity function against the same axis (usually x).
I run Excel 2003
 
If you plot two series You can select one of them and change the axis to
secondary.
In chart options you can then modify the Y axies as needed.
 
If it's a category axis, put the two sets of labels into adjacent
columns (or rows), select the chart and choose Source Data on the Chart
menu, then click on the Series tab and use the Category Axis Labels
input box to select this two-column (-row) range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top