How to use millions and billions in SAS VA as values for bar chart

[sassy7]

Hello,

 I would like to represent a bar chart that shows the sales of a certain product during the year: they asked me to move the chart x-axis, from a monthly time interval to a weekly time interval and here is the problem, how to visualize the amount sold if the bar is too thin (no cross-tab table below the bar chart.. sorry)?

With monthly bars, the bars was enough large to show the data value (millions of euro or even billions) but with weekly bars, the values tend to disappear until there is a drill down...

Which format allows to represent currency values (euro) from  1,2Mio euro or 1,200K euro to 1.200.000 euro according to the size of the bar?

[Rick_SAS]

See this previous thread, which shows how to use the PICTURE statement in PROC format to represents values in millions: Million Format

You can modify that format in a straightforward way to display billions.