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 a single line, with 1 y-axis being percent and the other
being whole numbers.

How do I do this? Everytime I try I send 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

Select the line (or point, if you're doing a scatter plot), right-click,
select "format series", and select the "Axis" tab. Then choose "second
axis". I may not have the names for the choices verbatim, but it's pretty
close.

Good luck!

Jim

" wrote:

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 a single line, with 1 y-axis being percent and the other
being whole numbers.

How do I do this? Everytime I try I send 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

hmm i couldn't get that to work.

i think I need to plot 2 series, 1 that corresponds to the %age axis
and one that correspondends to the whole number axis

but i only want 1 line to plot

any other ideas?

Make the second series invisible. [In Format/ Data Series, make the points
and line invisible.]
--
David Biddulph

wrote in message
...
hmm i couldn't get that to work.

i think I need to plot 2 series, 1 that corresponds to the %age axis
and one that correspondends to the whole number axis

but i only want 1 line to plot

any other ideas?