Sign in to follow this  

Formatting y axis values

Recommended Posts

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?



Share this post

Link to post
Share on other sites
Guest Sumedh



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


It would be easy to comprehend your requirement.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this