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 -