I have several line charts with data by day that gets updated daily. This means there are a lot of data points and I can set intervals manually or let Excel do it automatically. I'd like to have Excel do it automatically while always showing the most recent date regardless of where it falls in the interval. The only way I can think of doing it right now is changing the interval manually everytime to make sure the current date shows up on the axis labels or manually keeping the interval at 1 (which is the best solution currently as it requires no daily adjustments).
I've attached an example that is missing the latest 4/28 date on the axis.
Is this possible?
Bookmarks