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.