x axis on bar chart

[manoranjan_d]

Hi,

I m using dollar list box of  billions,million, thousand

where the value is

=If(amt='Millions', 1000000,

If(amt='Thousands', 1000,

If(amt='Billion', 100000000,1)))

its assigned to the vAmt variable

now i m using the bar chart

dimension as

MSG   field is used

expression as

=sum(spnd )/vAmt

now my issue is when ever i select the thousand or billions or millions in list box, my bar chart  x axes should always show the gap interval of 5 10 15 in the x axis to all the list box which select in dollar list box,

when ever i select the millions or billions or thousnand the gap interval in the x axis is getting differ

for example for billions 0.0000 0.0005 0.0010 0.0015

for millions 0.00 0.05 0.10 0.15

for thousand 0 50 100 150

so need this gap interval always to be same as 5 10 100 for any selection in dollar list box

[rubenmarin]

Hi, If your example for billions has left a '0' (0.00005 instead of 0.0005) you can use the 'static increment' in the axis tab, the increment can be:

=50000/vAmt

[manoranjan_d]

can u put me screen shot for this

[manoranjan_d]

statuc i have staic min and static max

[rubenmarin]

I don't have data but I'm tlaking of this:

[kaushiknsolanki]

Hi

Here is the image.

Regards,

Kaushik Solanki