1 Reply Latest reply on May 30, 2017 1:52 PM by Yuriy Fal

    Chart Auto-fit

    Sai Kiran V

      Problem: The data in the X-axis goes missing in between when the data is more.

       

      Solution: I am looking for a solution where the chart auto-fits the data and display all the labels.

       

      I can achieve this by keeping the worksheet setting Fit>Standard  in my dashboard. But my problem is it is creating a white space between the two graphs in my dashboard when the data is less as shown in below screenshot, which is not appealing.

       

      When i select the worksheet setting Fit>Entire View it works fine but when there is more data the X-axis doesn't show all the labels, as seen in the below screenshot.

       

      Do anyone have a solution for this, where i can see all my labels. Please refer to the Sample Store Workbook i have attached.

       

      Thanks in advance!

       

      -Sai