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.
