AJP Excel Information AJP Excel Information

Displaying the secondary X axis

Whilst the secondary Y (value) axis appears automatically when a data series is placed on the secondary axis the secondary X (category) axis requires you to enable it. Create a standard line chart based on the data in A1:C6
A B C
1 Rating Percentage
2 One 1.0 63.5%
3 Two 2.0 64.7%
4 Three 3.0 22.4%
5 Four 4.0 17.1%
6 Five 5.0 33.1%
Select the 2nd data series, right click and from the popup menu choose Format Data Series...
On the format dialog choose Axis and then Plot series on secondary axis
The secondary Y (value) axis is displayed automatically. To enable the secondary X (value) axis right click the chart and from the popup menu choose Chart Options...
On the Axes tab of the Options dialog enable the secondary Category axis

Created 28th April 2007
Last updated 5th August 2014 


Return to main page Chart Section VBA section Fun and games section Forum files Tips section Links section Book section Site information Site Search RSS feed Top of page


Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2014 Andy Pope