Alan Boba wrote:
On Nov 18, 2007 1:43 AM, Brian Barker wrote:
Alan Boba wrote:
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.)
Brian Barker wrote:
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
Thanks Brian I'm sure this will work. I had thought of it before posting but
was hoping to find if there is a way to "scale" the number displayed on the
chart axis without resorting to an extra column.
Don't want to give away my age but, way back when, I was able to do this in
Harvard Graphics for DOS and it seems to have been a component of most
graphing tools I've used since then.
I think it's a great capability because the data can be maintained in its
native form. The display of the data is altered as necessary for display
depending on the output requirements, e.g. audience, form factor (small
sheet of paper, low resolution on TV monitor, big high def wall projection,
etc.). And with this method there's no need to create new data, extra
columns, whenever a new display format is needed.
Did you consider using scientific notation for you x-axis?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
