AJP Excel Information
Displaying Y axis values on the right of the plot area
Create a standard column chart based on the data in A1:B6
A
B
1
Expenditure
2
Jan
56.3
3
Feb
22.3
4
Mar
46.4
5
Apr
92.7
6
May
15.5
Double click the X (category) axis in order to display the Format Axis dialog Select the 'Value (Y) axis crosses at
m
aximum category'
Created 28th April 2007
Last updated 5th August 2014
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2016 Andy Pope