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