Formatting Code for SI Units in Excel

[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?

 

[Stan Brown]

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.

 

[David Biddulph]

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

 

[Stan Brown]

Fri, 25 Jan 2008 10:36:06 -0000 from <"David Biddulph" <groups [at]
biddulph.org.uk>>:

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.