charting question

FAlbanese · May 8th, 2002, 02:14 PM

I was wondering if there is a way to have more than two axes on a chart? I have run into this problem several times and I can't fin a way to do, the most I can do is two. Most times this works, however I some times need to chart 3-9 separate series and due to units and magnitude, it is sometimes hard to see the trends.

Damon Ostrander · May 8th, 2002, 04:11 PM

Hi FAlbanese,

You can't have more than two ordinate (Y) axes on a single chart. However, you can overlay multiple charts in such a way that you can effectively have any number of axes. Just set the chart area and chart backround fill color to None, remove unnecessary x-axis labeling, etc., so that all that is visible is an x-axis with a few tick marks to provide correct registration, your new y-axis, and the series. You will want to offset the x-axis scaling so that the y axis does not fall on top of the underlying chart's y axis.

Mark W. · May 8th, 2002, 04:14 PM

Why not use a transform (e.g., 1 instead of 1,000,000 and label as "Millions")?

[ This Message was edited by: Mark W. on 2002-05-08 15:15 ]

May 8th, 2002, 04:11 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi FAlbanese, You can't have more than two ordinate (Y) axes on a single chart. However, you can overlay multiple charts in such a way that you can effectively have any number of axes. Just set the chart area and chart backround fill color to None, remove unnecessary x-axis labeling, etc., so that all that is visible is an x-axis with a few tick marks to provide correct registration, your new y-axis, and the series. You will want to offset the x-axis scaling so that the y axis does not fall on top of the underlying chart's y axis. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 02:14 PM	#1
FAlbanese New Member Join Date: May 2002 Posts: 2	I was wondering if there is a way to have more than two axes on a chart? I have run into this problem several times and I can't fin a way to do, the most I can do is two. Most times this works, however I some times need to chart 3-9 separate series and due to units and magnitude, it is sometimes hard to see the trends.

May 8th, 2002, 04:14 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Why not use a transform (e.g., 1 instead of 1,000,000 and label as "Millions")? [ This Message was edited by: Mark W. on 2002-05-08 15:15 ]