ExcelBanter - excel 2-y axis

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - excel 2-y axis (https://www.excelbanter.com/charts-charting-excel/172144-excel-2-y-axis.html)

I have a single set of data i want to plot, I have it presented as a
precentage of a whole and as whole numbers.

I just want to plot a single line, with 1 y-axis being percent and the
other being whole numbers.

How do I do this? Everytime I try I end up getting 2 lines.

I know how to setup a seconday axis, but i've never tried it for the
same set of data.

I am using excel 2007

Thanks

Answered in the other group.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

wrote in message
...
I have a single set of data i want to plot, I have it presented as a
precentage of a whole and as whole numbers.

I just want to plot a single line, with 1 y-axis being percent and the
other being whole numbers.

How do I do this? Everytime I try I end up getting 2 lines.

I know how to setup a seconday axis, but i've never tried it for the
same set of data.

I am using excel 2007

Thanks