6 Replies Latest reply on Dec 5, 2012 6:41 AM by Libitha Thinakaran

    Bar Chart Axis

    Dhaval Thakkar
    Dhaval Thakkar Aug 29, 2012 4:55 AM

      How can I change the range of the axis without changing the scaling of the bar graph? I have tried options under EDIT AXIS, but the option called 'Fixed' changes the sacaling of the graph. I just want to limit the graph to 40 % (Y-Axis is in percentage) instead of full 100%.

      This is the original Chart:

      1.jpg

      This is the Chart with Y-axis chaged to 40%

      2.jpg

      By doing so the chart is scaled by 0.4 times.

       

      I want the output like this:

      3.jpg

      So the scaling remains as the first chart but, the values displayed on Y-Axis terminate at 40%.

      • 1766 Views
      • Categories: Formatting & Display
      • Tags:
        • 1. Re: Bar Chart Axis
          Tracy Rodgers
          Tracy Rodgers Employee Aug 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
            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
              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
                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
                  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

                  Capture.PNG

                  • 6. Re: Bar Chart Axis
                    Libitha Thinakaran
                    Libitha Thinakaran Dec 5, 2012 6:41 AM (in response to Ian Devonald)

                    Thanks much Ian! It is helpful