Thu, 24 Jan 2008 11:27:03 -0800 from cjbarnwell
:
The x axis of my chart is frequency in hertz. So I want the numbers to read
1 10 100 1k 100k 1M

instead of

1 10 100 1,000 100,000, 1,000,000

There is no setting for SI units in the "Format Axis" ,"Number", "Category"
, so I assume there is a custom format code. Does anyone know how to do this?

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.

--
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/