Interactive Chart with INDIRECT Function and Named Ranges

Creating Reports with Excel Charts is quite Easy and Effective.

Whenever we create a Chart in Excel we need to keep in view the end users' requirement and need to understand how they want / need to play around the Data in the visualization.

Making an interactive chart gives more scope to the user to understand the Data in a much better way to take informed decisions for the business.

So to make a dynamic chart with interaction we must know few important tools of Excel viz., Functions, Named Ranges and Data Validation ( which are covered in this video) and many more.

Watch this video to understand how easy creating a Dynamic Chart! I hope this is the starting point for you if you have yet to explore Interactive Charts in Excel.

Keep Learning :)!

Don't Forget to SUBSCRIBE.

64 views0 comments