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?

awesome info everyone... doing the second axis was a peice of cake!

Thanks!

On Jan 9, 12:26*am, "Jon Peltier"
wrote:
Then scale the axes carefully so that the invisible and visible series
exactly coincide in the chart, or else the secondary axis will be
inaccurate.

You could also construct a custom fake axis using an XY series, as described
he

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

You don't need to muck around with secondary axes.

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in ...



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?- Hide quoted text -

- Show quoted text -