Barren_Wuffett
New Member
- Joined
- Aug 6, 2019
- Messages
- 18
Hey everyone, I have a fixed table with dates (x-axis on desired chart) that go for several years into the future, but data (y-axis) that only goes a few months. This will be a working file where new data is added each month. I'd like an area chart to show the data across the dates that have already happened (only the dates that have data). But if I select all of the data for the chart, the x-axis goes all the way out to the last date, which has no data. I'd like the chart to only show the dates for which I have data (x-axis automatically gets longer when new data is inputted each month). I know I could just adjust the chart data area every time, but I'd prefer it to be dynamic. Any ideas?