Excel 2 y axis

  • Thread starter Thread starter MHughes2
  • Start date Start date
M

MHughes2

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
 
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.]
 
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
here:

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 said:
Make the second series invisible. [In Format/ Data Series, make the
points and line invisible.]
--
David Biddulph

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?
Click to expand...
Click to expand...
 
awesome info everyone... doing the second axis was a peice of cake!

Thanks!

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
here:

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 message

Make the second series invisible.  [In Format/ Data Series, make the
points and line invisible.]
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top