How to Easily Toggle Between a Table and Chart Using a Dropdown List

[@DougHExcel]

If this video didn't fit, there are some other Dropdown List video at kzbin.info/aero/PL-n8f1cY_Qw9-ZSEpRN3OLmzYp4w54vht

[@DougHExcel]

...

[@saniel-khalil3234]

This helped so much. Thank you!!

[@PriscillaftJeremys]

omg thank you so much. I have literally searched how to do this for days, and here you are. HERO!

[@DougHExcel]

Hi Priscilla Everts, thanks for the kind words! Priscilla Everts, that is very interesting...thanks for letting me know.

[@donpierce4176]

For a new beginner in excel this is amazing, I enjoy your explanation simple and informative plus I have learnt a number of navigational tips. Thanks Doug ...

[@jayeshvaradkar7213]

Super useful for Dash boards reports Thanks Doug H , But i am getting one issue , during Link Picture Image which i m linking is very small size same as a cell size how to set is auto , as i have 4 diff charts with different size . Thanks you in advance :)

[@sheal123]

Very informative. Helped me a lot but I have a question: what if there are more than two available options in the dropdown list (say i have 20), will this still work? how will you have the excel IF formula set up?. Thanks

[@simfinso858]

very Easy way to teach.Nice & Helpful.keep posting

[@DougHExcel]

+sandeep kalyankar thanks for the comment!

[@Lucas-bz3lo]

Thanks! I was looking for something like this for setting up a dashboard. This seems perfect

[@HarleyEsguerra]

very cool dropdown and I can use this in a few of my projects....

[@wasimbader9170]

thank you, for this very informative tutorial.

[@astheidiotsblow]

From 3:40 for a few seconds did make me chuckle :') Could this be applied to switching between multiple tables?

[@DougHExcel]

Hi A Nicholas, thanks for the comment! Yes, it could be applied towards multiple tables :-)

[@HarleyEsguerra]

Is there a way to combine your Burndown Chart with this dropdown list? It would be cool is you can allow a user to choose from a dropdown list then update the table then flip back to the chart to see the change? I know that the link is an image so probably not possible. Would be cool to do.. I love the vids!

[@hulifox7153]

This video is very helpful! Thank you so much!! I have a question, and hopefully you can help. I have a wide table, let's say 100 columns by 30 rows. I want to display 20 columns at a time using drop-down list. And then, link the table to Powerpoint. The drop-down list is still valid in Powerpoint. The slides will get updated according to Excel changes. Any idea how to do that? Thanks again!!!

[@hulifox7153]

Thanks! It's very kind of you! I will check out this video!

[@deapriatamausman702]

Dough..thanks the share..i have an problem..when you give the example its only two can be changed..for chart n table..i have case have to change 5 table..it is can be use with your method or has other method..?

[@deapriatamausman702]

***** hi..thanks...do you have a sample video more than 2 chart..

[@ysemenov0024]

Tremendous help! Thank you

[@attarmanagement384]

love ya bro did me a solid was about to lose marks formatting on an assignment i had due BAHAHAHA IMAGINE KEEP UP THE hardwork :) sk

[@DougHExcel]

Thanks for the comment!

[@oxysuemalone9848]

I must be missing something. At 5:04 I get an error "Reference isn't valid". Any ideas around this? Love the vid by the way!

[@DougHExcel]

might need to check the referenced range

[@samarayan35]

Hi, its a very nice video but how about if i want to switch between two table, how can i do it?

[@DougHExcel]

the same way with the 1st table, just apply a name and instead of following the step of a chart, substitute the table name

[@shernandez31]

One question will this work with different tables instead of a table and a chart?

[@DougHExcel]

Hi Sebastian Hernandez, thanks for the comment! Yes it can

[@clariceannjaducana6481]

Is there any other way than link as picture? What I'm planning to do is that once the selection is chosen, I'm going to use the data in the table. The thing is, since its picture, I can't use the data. Thank you.

[@arsenefoka7739]

This is probably too late but, in your case you will have to reference the original table directly. You could give the table a name to make the referencing easier

[@DougHExcel]

maybe this can give an idea kzbin.info/www/bejne/epjEfYV8g9SKjZo

[@wasimbader9170]

are you " theExcelKid" bzc both of you are brilliant. lolz

[@simfinso858]

I will use this tricks in my official work

[@DougHExcel]

Hi sandeep kalyankar, glad you liked it, thanks for commenting!

[@heshamlotfy2173]

Good Job,,,,,

[@DougHExcel]

Thanks Hesham Lotfy!

[@simfinso858]

Sir plz make Master serial Number of Your videos from Day 1 & then Subject and then video number so I will quickly know how many videos posted by you in total & in this particular subject.For example 500/ 5/ 6 500= master total number 5= pivot table or statistics or finance function type 6= 6th video on pivot table If possible.it's Request

[@DougHExcel]

You can get his type of info my the playlist I create and can view my playlist here =>kzbin.infoplaylists

[@AbdullaKhizamworld]

Is there anyway we're I can link my drop-down list to slicer. Slicer is already connected to pivot table. Anyone??

[@DougHExcel]

maybe you'll find some insights from one of these kzbin.info/www/bejne/aonHq4aJpLhgmK8

[@lyntan4237]

i did the exact same thing but my picture still wont move according to my selection. why!! ;(

[@lyntan4237]

+Doug H what do you mean by that?