Effortlessly Create Dynamic Charts in Excel: New Feature Alert!
Excel
Jan 8, 2023 9:06 AM

Effortlessly Create Dynamic Charts in Excel: New Feature Alert!

by HubSite 365 about Leila Gharani [MVP]

Pro UserExcelLearning Selection

Join 300,000+ professionals in our courses: https://www.xelplus.com/courses/ Learn how to take advantage of dynamic chart ranges in Microsoft Excel. This way yo

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. 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.

  • Requires Microsoft 365

In this Video

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