Formatting y axis values

[CaptainStarbuck]

I'm a new user and have searched this forum but I haven't found an answer, sorry.

I have a simple line graph with values from 400k to 3.5m. Without any other options the y axis shows:

   0, 800K, 2M, 2M, 3M, 4M

 

One of my goals is to eliminate the duplicate 2M value.

 

I get my own max value and round up to the nearest 500k. So I set yAxisMinValue=0 and yAxisMaxValue=4500000, and the y axis shows:

   0, 900K, 2M, 3M, 4M, 5M

 

I'm still looking to see the yaxis value that I provide, as 4.5M or similar, so I set formatNumberScale=0 and get a y-axis as:

   0, 900,000, 1,800,000, 2,700,000, 3,600,000, 4,500,000

 

That's closer but I'd like to display the values in K/M. It's OK if the values are calculated but I'd like to see them more as 0.9M, 1.8M, 2.7M, etc. I can't get the y-axis to display decimals.

 

I tried passing the values as 0.9, 1.8, 2.3, etc, and then setting the y-axis label as "(in $M)", but I've tried the various attributes and combinations but I'm just not getting it.

 

I understand that we can't specify the specific y-axis values, but it would be nice to get a better handle on the format of whatever is displayed. People have been asking questions like this for years now and there doesn't seem to be any change in this area.

 

So in summary, how do we get a number like 847123.45 to display in a line chart where the y-axis is 0.9M , 1.8M, etc. ?

 

Have I missed any tutorials that show exactly how to manipulate these specific aspects of the y axis display?

 

Thanks!

[Guest Sumedh]

Hello,

 

Can you please share your chart XML and screen-shot here?

 

It would be easy to comprehend your requirement.