Hello,
i am heavily struggling with a current excel-project. I need a graph that visualizes certain values for every worday of the current week + the average values of the last 2 weeks. I managed to get the values in a certain order and the list itself can be updated daily without much effort. The problem now is, that the list is updating automatically every day, adding a new workday to the current week or "jumping" into a new week. With my solution the graph area has to be adjusted manually every day to allow for these changes. Due to the fact that the final project will have a lot of different graphs, i now need a chart that dynamically adjusts to these changes in my list.
I added an example of my logic as attachement and tried to add a better explanation of my problem + comments of my formulas and logics.
I would really appreciate any help i can get.
PS:i tried to use the "=OFFSET(XXX)" solution but i got nowhere with that.
Thanks in advance.
Siewi
Bookmarks