4 Powerful Dynamic Chart Designs in Excel

How to make dynamic charts in Excel that you can change without even clicking the chart - perfect for making a dashboard in Excel!

You will learn how to:
- Add/Remove data from a chart with the click of a button.
- Change the data on a chart using a drop down menu (combo box).
- Change data displayed on a chart using option buttons.
- Scroll through dates on a chart using a scroll bar.
- Generally speaking, how to use Form Controls with charts in Excel in order to make them dynamic and versatile.

The tricks that I show you in this tutorial will allow you to make more powerful charts that make it easier to analyze your data in Excel or even represent that data on a dashboard type interface.

Resources:

Chapters:
00:00 Intro
01:00 Dynamic Filtering
03:26 Setup for Using Form Controls
06:37 Drop Down Menu w/ Chart
09:14 Option Buttons w/ Chart
11:27 Scrollable Dates

#msexcel #tutorial #freetutorial #exceltips #excel

[mr.jaycasey]

Excellent information. I had never used a group box before. Very useful! Thank you!

[bentatlim]

Really brilliant 👌Thank you very much! It would be AMAZING if you can show us in a video how we can create a dynamic Chart, where i can choose the Periods (Year, Month or week) . So that the user can choose with a button/dropdown if the x - axis, show the years or month or Weeks. 🙌🏼🙌🏼 I try it since days in excel, but without any results 😭 Please help ❤ I check all your videos, but cant find anything 😭 Thank you. Regards from Germany.

[alfonsoable]

thats execelent thanks for the support

[nadermounir]

very nice tutorial. thank you for sharing your knowledge with us :)

[enrikekasijas]

Thank you very much !:) Very useful stuff, Simple and complex at the same time but most important...smart xD

[bsa]

Or you could just use a slicer and save a lot of needles work