Display Column Chart Y Axis Labels in Kilo(K), Million(M)...

[Former Member]

Hi Folks,

I would like to display the Y-axis labels of a column chart in Kilo, Millions etc. I used the below mentioned formula in excel for that set of data. Here is the formula [>=1000000]0,,"M";[>=1000]0,"K";0

Though in embedded excel it displays the values as desired, when I assign them to the column chart in Xcelsius the Y axis labels are not as expected. For Kilo it works fine but when it comes to millions it is not displaying accordingly. Any help is appreciated.

Thanks,

Sukumar

[Former Member · Accepted solution]

Hi

You do not need to create a formula for this. Within the charts properties you can set it to display the labels (M/K/T etc), look on the behavior tab.

Does this not work for you?

Thanks

Charles

[Former Member · Accepted solution]

Send me that XLF file to my mail

[Former Member · Accepted solution]

Thanks Charles!

[Former Member]

Hi Sukumar,

If You want to display the Y Axis Labels like Kilo(k),Million(M),Billions(B)...etc.Do the following things ,

goto column chart properties->behaviour->scale in that Enable the Fixed Label size checkbox.

Regards,

Ramana

[Former Member]

Thanks Ramana!