Charting Technique

[Harshdhupia]

Hello!!


I want to make a double y-axis chart as is given in the following link http://www.lytebyte.com/wp-content/uploads/2009/02/multipleyaxischartinexcel20071.png


Can someone help me in preparing such chart.

 

[Hui]

Harshdhupia


Firstly, Welcome to the Chandoo.org forums.


Select the series you want on the Secondary Y Axis

Right Click

Format Series

On the Series Option Tab, choose Plot Series on Secondary Axis

 

[bobhc]

Harshit Dhupia

This link does what Hui has told you but there is a video to show just how easy it is to do, quicker than reading this post


http://chandoo.org/wp/2009/07/02/secondary-axis-combination-charts-howto/