Create a Dynamic Chart with Checkboxes




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

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

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!

Leave a Reply

Your email address will not be published. Required fields are marked *