Million Format

building reports desktopintelligence
1

Hi All

Can you help?

I’ve just plotted a line chart of credits and debits. The Y-axis shows actual amounts eg 1,000,000, 2,000,000, 3,000,000. This takes a lot of space on the graph.

Is there a format I can create for it to just show the million prefix eg 1, 2, 3. I can then add a label to the axis to show it’s in millions

Thanks is advance

Steve

laylos (BOB member since 2008-09-17)

2

before turning the table into a chart, divide the variable by 1,000,000 in the cell. Now convert it to your chart and put a legend on your chart explaining that the values are in Millions of $.

andrewp :us: (BOB member since 2009-03-17)

3

Thanks

I thought about this but don’t really want to take the chart apart back to table and re-plot. Also, don’t want to process more data and hopefully could do it through a format.

Any more?

Cheers
Steve

laylos (BOB member since 2008-09-17)

4

If you don’t want to take it back to a table, create a new variable
V_Actual_Amts = Actual Amts/1,000,000

Go to format block/pivot --> remove actual amts and replace with V_Actual_Amts

Then in the chart, click on the new value label --> right click
select “format axis label”

Select Category “Number” In the properties positive box, then - type in # M

This should get what you want

DC

MBTDC :us: (BOB member since 2007-12-28)

5

Magic, it worked!

Thanks Guys and have a great weekend! I’m off home

Cheers
Steve

laylos (BOB member since 2008-09-17)