Hi there! I don't even know how to explain this but I will try. I uploaded a picture. As you can see, the little line chart under the sales did not update, it stayed the same. How can I have this chart automatically update? Is it possible in Excel?
Hi there! I don't even know how to explain this but I will try. I uploaded a picture. As you can see, the little line chart under the sales did not update, it stayed the same. How can I have this chart automatically update? Is it possible in Excel?
Please post a link to the solution you tell us you have found on YouTube for the benefit of others here. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Apparently, it's called Dynamic Rolling Chart and the code is made of OFFSET function.
https://www.youtube.com/watch?v=SR_314s8h_M
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks