> > >> 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? > > > >> 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 > >> > > > > Alan Boba wrote: > > 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. > > > > 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. > > > > >
Joe Conner wrote: > Did you consider using scientific notation for you x-axis? > > Hadn't thought of that. It works of course. The audience is the problem though. Business users are comfortable with "B" and "M" and "K" after the dollars, like $1.5B, $1.5M, $1.5K. Having that "E" in there and a power of ten after isn't going to help them read the chart. If I'm ever in front of the right audience I can use it. In the mean time I'll do the extra column and put in an enhancement request.
