How To Create A Dynamic Chart In Excel

This video will take you through the steps of creating a chart that dynamically changes based on the selection you make from a Data Validation drop down list. We’ll use various functions including INDEX, MATCH, COLUMNS, and ROWS.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.


What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

2 Responses to How To Create A Dynamic Chart In Excel

  1. MJ September 28, 2015 at 1:24 pm #


Leave a Reply