I want to show Y -Axis doller format
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
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.
Its not working for me i trying the same way
is there any another way
Odd... I just tried it again and it worked. Could you attached your document with some sample data?
How can i dicrease my bar width
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.
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.
Thank you guys .....
Retrieving data ...