Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Secondary X-Axis

Posted by Jeff Timkins on August 21, 2001 10:23 AM

I see an option for naming a secondary x-axis in a chart, but I cannot find a way to add the x-axis. Instructions are only given for adding a secondary y-axis. Anyone know how to do this?

Re: Secondary X-Axis

Posted by Mark W. on August 21, 2001 11:46 AM

Select the series that you want placed on the 2nd
x-axis, and choose the Format | Selected Data Series...
menu command. Select the "Secondary axis" radio
button on the "Axis" tab.

?that only gives me a second y axis

Posted by Eric on August 21, 2001 1:06 PM

Now what am I doing wrong?

Yep...however, upon further review...

Posted by Mark W. on August 21, 2001 2:04 PM

I think I have the correct answer. A secondary
x-axis is only supported for the XY (Scatter) chart
type. Using the Chart | Source Data... menu command
you can specify separate X-axis values for each
series. Then using the Chart | Chart Options...
menu command you can activate the display of the
secondary x-axis scale on the Axes tab.

Boy, made me work, but that was fun!!! : )

nice job, thx (NT)

Posted by Eric on August 22, 2001 6:05 AM

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.