BarChart

[NavinReddy]

Dear All,

I want to show Y -Axis doller format

$1,400

$1,200

$1,000

like the format i need to be show how can i do this could you please some one guide me

And Bar width also how can i dicrease

please give me an idea

Thanks In Avance

Niranjan

[mikecrengland]

Hi Niranjan -

Unless something has changed, there's not a good answer. you need to format for money and use Static Min, Max and Step, and then that only works if something is filtered. Once you clear filters, the $ goes away.

Mike

www.fortunecookiebi.com

[NavinReddy]

Hi Mike,

Its not working for me i trying the same way

is there any another way

Regards,

Niranjan

[mikecrengland]

Odd... I just tried it again and it worked. Could you attached your document with some sample data?

[veidlburkhard]

Hi Niru,

i) Money sign: in the 'Number' tab you can define a money sign (dollar) for the y axis. See below an example:

ii) Size of the bars: Go on 'Presentation' tab and adjust the 'Cluster Distance' accordingly. This allows you to arrange the size of your bars:

Hope this helps.

Burkhard

[NavinReddy]

Thank you guys .....

[NavinReddy]

Hi Mike,

How can i dicrease my bar width

Best Regards,

Niranjan

[mikecrengland]

The only way that I know of is like Burkhard mentioned... to increase the cluster distance. The bar width will change with the width of the chart.