In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.
Dynamic charts allow you to change the chart based on user selection. For example, you can update the chart as soon as you change the scroll bar or click a button or make a selection from a drop-down list
This video covers two detailed examples of creating dynamic charts from scratch
Example 1 – Creating a dynamic chart that updates as soon as you use the scroll bar to change the year value.
Example 2 – Creating a dynamic chart that plots the data on a scatter chart based on the column you select. There is a drop-down that allows you to select which data series should be plotted on the X-axis and which should be plotted on the Y Axis
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: http://bit.ly/2snelIX
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:
-~-~~-~~~-~~-~-
Let’s Connect:
Google+ ► http://bit.ly/2jWiOzU
Facebook ► http://bit.ly/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► http://bit.ly/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel