Displaying dual Y axis values

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 maximum category'

Charting tip

Last updated 28th April 2007

Home | Charts | VBA Code | Fun Stuff
Newsgroups | Tips | Links | What's New | Book List
Contact | About

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