This video shows you how to create a dynamic rolling chart to show the last 6 months of data. Whenever new rows are added, the chart automatically updates to consistently display the last 6 months.
This technique can easily be updated for any other rolling time frame such as the last 12 months, 10 days or 6 weeks.
Two dynamic named ranges are created for the dynamic source data. One for the chart data and another for the chart labels.
These named ranges are set up using the OFFSET function. The chart is then edited to use these named ranges for its source.
Find more great free tutorials at;
www.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
5 окт 2024