About this tutorial:
Video duration: 11:6
Check out my Blog:
If you want to show multiple views of a chart, sometimes it may involve letting your audience select some criteria so they can see different views of the data. You’d want to embed some kind of interaction for your users and putting together a dynamic, interactive chart may be your option. To learn how to create a dynamic combination chart (with check boxes to choose with chart series to show) check out this video.
#exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel
22 thoughts on “Create a Dynamic Chart with Checkboxes”
Leandro Larrousse
(December 8, 2018 - 9:10 am)Thank You!
SALIF DIALLO
(December 8, 2018 - 9:10 am)excellent
Palash Bhattacharjee
(December 8, 2018 - 9:10 am)really very helpful video. THANKS.
pls upload some more videos of dynamic charts with macros.
Pariyanuch P.
(December 8, 2018 - 9:10 am)I would like to put this on google site by ticking the checkboxes Can you do this ?
diemcim
(December 8, 2018 - 9:10 am)You are the best! Thank you!
manjusha isac
(December 8, 2018 - 9:10 am)Is there any way to add two data validation list in the same column of a google sheet , and two list must be slelectable @ the same time
akrem jemai
(December 8, 2018 - 9:10 am)great thanks
Thushara Indralal
(December 8, 2018 - 9:10 am)Amazing… thanks.. it's a great video
Hesham Lotfy
(December 8, 2018 - 9:10 am)Great my Dear, kindly can we use product A and Product B and profit for one sales representative and Make another one in same chart for products A and B and profit but for another person at the same time
Hesham Lotfy
(December 8, 2018 - 9:10 am)Great,,,,,,,,,,,,,,,,,,,
JEWEL PLATA
(December 8, 2018 - 9:10 am)Cool thanks😊
ShayanGaming
(December 8, 2018 - 9:10 am)Thank you so much! Amazingly explained! 😀
Syed Muzammil Mahasan Shahi
(December 8, 2018 - 9:10 am)Wow. Brilliant
Ahsan Abas
(December 8, 2018 - 9:10 am)Excellent!!
Elin Carlsson
(December 8, 2018 - 9:10 am)Hi! Thanks for the very interesting and useful tutorial. However, after your video I have been struggling with the secondary axis introduced at the end of the tutorial. When unchecking the profits-checkbox, the secondary axis does not dissapear, but shows only zeros and ones which is not very neat. I would be very thankful if you have any solution on how to remove the secondary axis when the profit-checkbox is unchecked. All the best!
Raymond Vermeulen
(December 8, 2018 - 9:10 am)Very helpful!
Rob M
(December 8, 2018 - 9:10 am)Thank you, this helped me a lot.
Marek
(December 8, 2018 - 9:10 am)Why not just use Charts("X").SeriesCollection(X).Format.Line.Visible = True or False?
S Devarajan
(December 8, 2018 - 9:10 am)Really dynamic!
Shampooworld
(December 8, 2018 - 9:10 am)Thanks!
Mark Moretto
(December 8, 2018 - 9:10 am)Great video. Two points:
1. If you want to hide those Checkbox/True/False cells, reformat as special and type ";;;". So, three semicolons.
2. Is there a way to keep the left-side scaling firm at all?
Erica Dyson
(December 8, 2018 - 9:10 am)Great. Very clear and useful!