Second Y axis in Excel

[datadan]

I can do a standard XY line chart in Excel. However I want to add a second Y axis on the right side. For example I want Unit Quantities on Y1 and I want Percentages on Y2. How would I accomplish this?

Date1 Date2 Date3
Units 400 500 600
% 10% 15% 20%

Thanks for your help.

 

[xlbo]

Create a normal chart, then right click on the series you want to put on the 2nd axis, one of the option tabs will have an axis option
Choose "secondary"
et voila Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[datadan]

Thanks a bundle....

The people on this list are so good!