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

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.

"Alan" wrote:

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 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/
_______


Alan wrote:

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