Tag: Offset
How-To Make a Dynamic Excel Scroll Bar Chart Part 2
Wow, it has been over 2 years. I am so sorry if you have been waiting all this time. Probably not, but I will finish...
Show Only Selected Data Points in an Excel Chart
So last week I posted this question in the challenge:
Here the user story on what we are trying to do:
‘As an Excel user I...
How-to Create a Sick Leave Excel Dashboard Chart
Okay, I got an email from a SUPER FAN of my sight. She even donated some money to help cover the costs of that...
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
This is the Bomb: or How I came to love the Offset function
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...
