Creating Dynamic Charts to Compare Two Different Data Series in Excel
Expert Excel With Dr. Chang - Episode 4
Creating Dynamic Charts to Compare Two Different Data Series
Charts in Excel are usually created as a Static Chart. When you have to update the data, the charts are not updated, and you have to modify the chart settings manually.
The video shows one approach that allows us to create Dynamic Charts in Excel by using Match and Index values to update the values in the prepared grid automatically with the selected values from a Dropdown List. Extending this approach can allow us to compare two different data series quickly.
Additional Resources:
Example Data Set and Solution:
https://bit.ly/3zVVYy8
Understanding Match and Index Function in Excel:
• Match and Index Function in Excel
How to Create Drop-Down Lists in Excel:
• Creating Drop-Down Lists in Excel to Preve...
If there are any requests for Excel Tips and Tricks, please write them down in the comment and I'll try to create a video answer in the future.
By Asst. Prof. Dr. Pisal Setthawong
Department of Digital Business Management
Assumption University
Facebook:
/ pisal.setthawong
Twitter:
@PisalST
Music Credits:
Cyberleaf Studio - TechShow Loop 1