At 00:24 18/11/2007 -0500, Alan Boba wrote:
I'm trying to find if there is a way to do a specific type of number
formating in Calc, what I'll call 'scaled' formating.
If I'm using numbers like 1,000,000,000 (one billion), 2,000,000,000
(two billion), etc. and I want them to display on a graph axis as
1.0 B, 2.0 B, etc. is there a format I can apply to the graph axis
to make the numbers display like that? If yes, what is the format code?
If there's not a format to apply to the axis is there a format that
can be applied to the cells to make the numbers display that way.
Again, if there is what is that format? (I would use the chart
feature that says "use source formating" in this case.)
The only difference I can see between choosing to format the values
explicitly in the chart and using the "Source format" option that you
mention is that the source format option allows you to format the
x-axis values as well as the y-axis ones. Otherwise, there appears
to be no way to control the formatting of the x-axis values in the chart.
I don't see any way, in fact, to get the values on the chart to be
different from those in the data range. In other words, as you need
one billion to appear not as itself but as "1.0" (irrespective of the
"B"), you will need to construct a new data range first with the
values scaled down by a factor of one billion and then use that to
plot the chart. If this means creating a new column or columns with
the scaled data, there is no problem in having your existing data
interspersed between the required columns: the unwanted column(s) can
be excepted when the chart is constructed. (Use "Remove" on the
third panel of the Chart Wizard.)
Whichever route you take, to get the "1.0 B" format, you just enter
0.0 \B
or
0.0 "B"
(or similar) as the Format code. Actually, since "B" has no meaning
as a format code, you don't need the backslash or quotations marks in
this case, and could use just 0.0 B.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
