Search This Blog

September 5, 2011

Create two Y Axis



First plot the data on existing y axis

The result may seem absurd for the moment

Then

Select the line> Right Click> Format Data Series> Series Options > Plot Series On >>> Select Secondary Axis

And Vella !!!!


Now please don't ask the logic behind it.

http://www.techonthenet.com/excel/charts/2_y_axes.php 

No comments:

Post a Comment