Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Alan
 
Posts: n/a
Default 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
  #2   Report Post  
bj
 
Posts: n/a
Default

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

  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Right axis instead of left axis in chart saturnin02 Excel Discussion (Misc queries) 5 April 29th 23 11:42 AM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
How do I eliminate duplicate values on y axis of an Excel chart? Paul Charts and Charting in Excel 1 March 24th 05 04:26 AM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"