Fri, 25 Jan 2008 10:36:06 -0000 from <"David Biddulph" <groups [at]
biddulph.org.uk:
"Stan Brown" wrote in message
t...
I think the real issue is that you're trying to show a logarithmic
scale. I don't know of any way in Excel 2003 to do that, without
transforming the data yourself. There's a "logarithmic" type in the
misnamed "Custom" category, but it presents two parallel time series
rather than an x-y plot.

I'm confused, Stan.

Can't you just select the logarithmic option on the Scale tab, and then use
Custom on the Number tab to call up
[=1000000]#,," M";[=1000]#, k; #
?

I imagine "I'm confused" is a euphemism. :-)

I couldn't see any way to do it in Chart Wizard, so I gave up because
I thought all the options were there. But I see there are a whole lot
more in Format Axis, including the logarithmic one you mention.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/