Hi everybody,

I have three sheets with data on monthly, weekly and daily basis to create diagrams.

On certain dates the diagrams should show "events". For example a change or a problem on IT side could be the reason for a decrease or increase of call volume.

An ideal solutions would contain a fourth sheet with a list of events. Probably I would need some helper tables for the monthly, weekly and daily timeline.

Does anybody have an idea how I could solve this problem?

Thanks in advance!
eyestorm