Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Secondary X-AxisPosted 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-AxisPosted 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 axisPosted 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.