-
1. Re: Bar Chart Axis
Tracy RodgersAug 29, 2012 9:06 AM (in response to Dhaval Thakkar)
Hi Dhaval,
This seems odd, and I have not been able to recreate it using sample data. Would you be able to post the packaged workbook (twbx file)?
-Trcy
-
2. Re: Bar Chart Axis
Dhaval Thakkar Aug 29, 2012 11:24 PM (in response to Tracy Rodgers)Thanks Trcy.
I was able to figure this out.
I was using a dual axis and so fixing the axis was giving an odd output.
On removing the other axis and fixing the percentage axis to 40%, I was able to get the required visual output.
Thanks again for your time.
Dhaval
-
3. Re: Bar Chart Axis
Nayana Wagle Sep 10, 2012 7:45 AM (in response to Dhaval Thakkar)Hi folks,
I have a generic question on this issue. I have different charts with percentage values that could potentially range from 0% to 100%. So my scale needs to be able to cover the entire 0-100%; I can't fix the scale.
However, many times, the values are 90% or above. When I make the scale "automatic", the axis ranges from 0 to 100% and all the values bunch up at the top.
Is there a way to make the axis "dynamically" zero in on the range where the values are? For example, if they are all in 90% above range, can I indicate to Tableau to make the scale 90 - 100%; but if there is some value say at 40%, then I want Tableau to scale from around 35 to 100%.
So I don't want the scale to be either generally "fixed" or "automatic" - but more a decision based on the data points.
Thanks!
-
4. Re: Bar Chart Axis
Libitha Thinakaran Dec 5, 2012 5:27 AM (in response to Nayana Wagle)Hi All,
Even i am facing the issue of dynamically changing the axis of bar chart as per the data. Like if most of the values are in the range of 80-100, the axis should also change accordingly instead of starting from 0 to 100. Can anyone suggest some solution for this.
Thanks!
-
5. Re: Bar Chart Axis
Ian Devonald Dec 5, 2012 5:46 AM (in response to Libitha Thinakaran)Hi Libitha
There is a check box to 'Include Zero' when choosing Automatic Axis. If you uncheck it as per examples on attached workbook then this should scale your axis. To Edit Axis right click the axis and choose Edit Axis...
Hope this helps.
Ian
-
6. Re: Bar Chart Axis
Libitha Thinakaran Dec 5, 2012 6:41 AM (in response to Ian Devonald)Thanks much Ian! It is helpful