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?

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/

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; #
?
--
David Biddulph

"Stan Brown" wrote in message
t...
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/

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/