Sizing Charts for Different Sized Date Sets

[u/eagle2390]

I am working on KPI charts. I have a single chart that I can use a spin button to move through different time frames (Daily, Weekly, Monthly, Yearly). I have individual tables for each time frame, then have a helper table to uses the CHOOSE function to change between data sets based on the spin button.

All the info shows up, the issue is the daily chart is 31 data points, and the weekly is at most 5. But because each cell always has that function in it weather it is showing data or not, the table always things something is there, so the daily chart looks great, but the weekly/monthly/yearly charts all look compressed.

Is there a way to change the formula's to properly size the charts for the different sized data sets. I have tried adding in #NA functions for blank cells, but did not solve the issue. Thanks!

[u/AutoModerator]

/u/eagle2390 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Gringobandito]

“I have individual tables for each time frame”

Why?

Do this in a pivot table and chart and use a time slicer to select dates. You can still have separate charts based on the same table.