Chart Y axis display billion

[artemis_ai]

Hi, I am going to build a chart in cognos 10.2 in report studio , and in Y axis, I want the data display million/billion instead of detail data, like 1,000,000,000 show 1billion, I tried to change the Axis labels data format to Currency , and enter Billion in Currency Symbol, symbol position is End, and scale selected -9, but the result is only display Billion beside the data, like 1,000,000,000 billion . Can you help to figure out the reason and find the solution ?thanks.

[Andrei I]

Data Format - Pattern :  #### Billion

[artemis_ai]

Hi stork,

Thanks, I tried, but the number in the chart Y axis still showing the full number in excel output, but ok in HTML..can we realize it in excel?