تقييمات الطلاب
( 5 من 5 )
١ تقييمات
فيديو شرح Creating Dynamic Charts in Excel (Using Drop-down List and Scroll Bar) FREE Excel Course ضمن كورس اكسيل المحاسبي شرح قناة TrumpExcel، الفديو رقم 23 مجانى معتمد اونلاين
In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.
It covers two examples that show how to make charts that are dynamic and are dependent on the drop-down list selection and scroll bar (2 examples)
Dynamic charts in Excel 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 in Excel.
Example 1 - Creating a dynamic chart that updates as soon as you use the scroll bar to change the year value. The scroll bar value is linked to a cell and that cell is used to get the data for the chart.
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 dynamic chart 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: https://trumpexcel.com/learn-excel/
Download File - https://trumpexcel.com/course-downloa.
If you find the videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?vUPABcYhugZk&listPLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial