Formatting Code for SI Units in Excel
 

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?

Formatting Code for SI Units in Excel
 

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/

Formatting Code for SI Units in Excel
 

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/

Formatting Code for SI Units in Excel
 

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/