Charts

[#1]

I am getting the Y axis dimension as 150000,100000,50000 but i want to convert them into 150,100,50 ??????????????

[#2]

From where i can get the format  pattern for displaying the dimensions like  0.50,100,150  in the line chart ??  

[#3]

I guess you dont have control in giving the scale.

[vupen · Accepted solution]

You can control the display of the units on the Y-axis(Expression value) by specifying a symbol for either Thousands, Millions or Billions. This can be done on the Number tab of the Chart properties dialog.

Based on the symbol specified, the Y-axis value is divided by one of those numbers (thousand/million/billion).

However, the actual expression value remains the same.

Attached is a sample file.

[#5]

when i am creating a chart I am getting the values on Y axis as 20000,150000,100000, but i want to further break it and also want the negative values ?????? plz help

[vupen]

Work around is to multiply/divide the expression value with a constant like <exp>*-1/5000.

If you can be more specific as to what 20000 should become, or what value be translated into a negative value, then I can suggest something.

[#7]

on Y axis  I am getting the value like this (0 , 50000,100000,150000,200000) and i want it them to be like (  -20000,0,20000,40000,60000,80000,100000,120000,140000,160000,180000,200000,220000)

[vupen]

I believe you want a 'Static Axis', irrespective of the Y value. You can achieve that by setting Static Min, Static Step and/or Static Max on the Axes tab of the chart properties.

Attached is the sample.

[#9]

yea thats correct

[#10]

what you said i tried but it is not working properly ,  i am trying in combo chart ???????????????