Automatically scale horizontal axis to different table sizes

[BRISBANEBOB]

I am limited for screen space, and I need to let the user choose which of two charts to display. On the horizontal axis one chart has the days of the month, and the other shows the summary by week showing up to 5 weeks. How do I do this?

[DBY]

Hello
Take a look at the attached example. It uses the CHOOSE function to pick between selected values: "Daily Cumulative" and "Weekly Cumulative". The ranges are also dynamic using the OFFSET function to eliminate the "#N/A's".

Hope this helps.
DBY

[BRISBANEBOB]

Thanks DBY, that's exactly what I was looking for. Your help is aprreciated