Uploaded January 2023 | Updated September 2026, 9 hours ago
🔥 Create charts that wow your audience. Learn the secrets now—start today! 👉 link.xelplus.com/yt-g-dyn-range-charts-course
Learn how to take advantage of dynamic chart ranges in Microsoft Excel. This way you can create a perfect chart even when the data range gets bigger or smaller based on criteria. No more white space or empty spaces in your chart.
🎓 400,000+ professionals trust our courses—start your journey here 👉 link.xelplus.com/yt-d-all-courses
Grab the file I used in the video from here 👉 pages.xelplus.com/chart-dynamic-file
The chart range also automatically expands if you have new data. You no longer need to use name manager or create advanced Excel functions together with name manager to have dynamic chart ranges. You have it now in-built as long as you use Dynamic array formulas or Excel functions that spill (or use the hash to spill a range). If you have this in place, and you create an Excel chart based on this range, the chart will automatically adjust as the range gets smaller or longer. This is a great time-saving feature specially when you create Excel Dashboards.
Note: Requires Microsoft 365
00:00 How to Remove Empty/White Space From Your Chart
00:39 Preparing the Filtered Data
02:52 Insert the Chart
04:26 Cool Dashboard Chart Trick
09:37 Wrap Up
🌍 My Online Courses ► xelplus.com/courses
🎬 LINKS to related videos:
Excel What-If Analysis Data Table: youtu.be/4VuO1lO6USo
How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions: youtu.be/p92Ta3J5vGU
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
🔥 Create charts that wow your audience. Learn the secrets now—start today! 👉 link.xelplus.com/yt-g-dyn-range-charts-course
Learn how to take advantage of dynamic chart ranges in Microsoft Excel. This way you can create a perfect chart even when the data range gets bigger or smaller based on criteria. No more white space or empty spaces in your chart.
🎓 400,000+ professionals trust our courses—start your journey here 👉 link.xelplus.com/yt-d-all-courses
Grab the file I used in the video from here 👉 pages.xelplus.com/chart-dynamic-file
The chart range also automatically expands if you have new data. You no longer need to use name manager or create advanced Excel functions together with name manager to have dynamic chart ranges. You have it now in-built as long as you use Dynamic array formulas or Excel functions that spill (or use the hash to spill a range). If you have this in place, and you create an Excel chart based on this range, the chart will automatically adjust as the range gets smaller or longer. This is a great time-saving feature specially when you create Excel Dashboards.
Note: Requires Microsoft 365
00:00 How to Remove Empty/White Space From Your Chart
00:39 Preparing the Filtered Data
02:52 Insert the Chart
04:26 Cool Dashboard Chart Trick
09:37 Wrap Up
🌍 My Online Courses ► xelplus.com/courses
🎬 LINKS to related videos:
Excel What-If Analysis Data Table: youtu.be/4VuO1lO6USo
How To Use the new Excel TEXTBEFORE & TEXTAFTER Functions: youtu.be/p92Ta3J5vGU
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
