Making dynamic chart in Excel
October 30, 2015
It’s been quite some time since I wrote a How-to-post. Here’s an Excel-thing that I managed to solve today that’s been bothering me for a long time.
Here’s the scenario:
- We have plenty of data points, one per day, counting something (really the number of patients per day but it can be anything). This is displayed in a diagram like the one above.
- After 2 months this starts to get out of hand looking at and really we’re only interested in the last 30 days
- Sometimes though it could be fun to see more data in one view
Basically we want the diagram to dynamically show the last 30 days (or any other number of days we fancy). Like a 30-day window backwards.
This post describes how to do that.
DISCLAIMER I have, for some stupid reason, a Swedish Excel...