https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-use-millions-and-billions-in-SAS-VA-as-values-for-bar/m-p/776716#M15527 <P>Hello,</P><P>&nbsp;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)?</P><P>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...</P><P>Which format allows to represent currency values (euro) from&nbsp; 1,2Mio euro or 1,200K euro to 1.200.000 euro according to the size of the bar?</P> Wed, 27 Oct 2021 11:54:41 GMT sassy7 2021-10-27T11:54:41Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-use-millions-and-billions-in-SAS-VA-as-values-for-bar/m-p/776716#M15527 <P>Hello,</P><P>&nbsp;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)?</P><P>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...</P><P>Which format allows to represent currency values (euro) from&nbsp; 1,2Mio euro or 1,200K euro to 1.200.000 euro according to the size of the bar?</P> Wed, 27 Oct 2021 11:54:41 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-use-millions-and-billions-in-SAS-VA-as-values-for-bar/m-p/776716#M15527 sassy7 2021-10-27T11:54:41Z https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-use-millions-and-billions-in-SAS-VA-as-values-for-bar/m-p/776737#M15532 <P>See this previous thread, which shows how to use the PICTURE statement in PROC format to represents values in millions: <A href="https://communities.sas.com/t5/SAS-Programming/Million-Format/td-p/440121" target="_self">Million Format</A></P> <P>&nbsp;</P> <P>You can modify that format in a straightforward way to display billions.</P> Wed, 27 Oct 2021 13:57:22 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-use-millions-and-billions-in-SAS-VA-as-values-for-bar/m-p/776737#M15532 Rick_SAS 2021-10-27T13:57:22Z