Awesome easy to follow instructions! I work for an aerospace manufacturer and creating these combination charts are a must and also a "wow" factor during meetings :) thank you.
Doug, I think your videos are simply great and very easy to follow. So thanks a bunch, I had done question, is this possible on Power Point 2010 with check boxes, could you make a video.
Thats really nice of you and also very helpful to me when show up the problem in my work. However, When I use the group box I cant group the check box together. Do you know the reason the quick rep for me. Thanks in advance
Thanks. Nice way of presentation. Suppose I paste special this dynamic chart in ppt, will this check box work? (without double clicking the chart and working in the xls)
It depends on how you use Pivot Charts, but user friendly options include slicers to help filter data. If want to explore slicers I have a video here at th-cam.com/video/jC98mWjI3ZA/w-d-xo.html
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?
For #1, thanks for adding knowledge to the thread! For #2 I'm not sure I understand the question, but if it is keeping the left axis value maximum static, that would be to right click the Y axis, format axis and set it at some maximum value so it doesn't changed on each chart selection.
Yep, thanks Doug. I tried it after I posted the question and, as in your video, if you have 'Auto' set, it'll do dynamic scaling. But, like you said, you can set values to keep the charts static. Thanks again!
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!
Hi Doug H, is there a way to use this dynamic chart that allows you to change the X axis when you check, and uncheck the checkboxes? Let's say we didn't use data for the 'Years' but instead Product A was 'Vegetables' and Product B was 'Fruit'. If you checked Product A you would see Potato, Corn, Carrots etc instead of 2000, 2001, 2002, and if you unchecked that and checked Product B you would see Plum, Apple, Orange etc. I know the configuration of the table may need to be altered slightly. Does that make sense and could you please do a tutorial of how I could achieve that? I appreciate your tutorials so much and gain so much from them. PS: I am so sorry that my comment posted so many times previously. I was posting from my phone and it said it was unable to post my comment so I kept trying, only to get on my laptop and see multiple posts - of which I ended up deleting them all and not leaving the original! Fail. ;P
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
Though not exactly the same scenario, maybe these video will give some insight = > th-cam.com/video/6ekd_j0G0b0/w-d-xo.html th-cam.com/video/taTnVeEQFSA/w-d-xo.html
I can see this as helpful in creating a dashboard but not practical if you have to repeatedly set it up again as the data changes. You would have to recreate the logic table, wouldn't you? Maybe the same effect could be achieved with slicers.
Simple, easy and best to understand. Thanks Doug.
Doug, how smart you are. You're my hero. You gave me a perfect solution to create a interactive dashboard. Thanks a lot.
Hi Jenny Kim, thanks for the kind words!
Love it! Great video!
This is great, thank you Doug! You've made something so technical so easy to learn. I appreciate your videos.
This is so useful. Thank You Doug
Great tips with clear instructions, thanks for your helpful video.
You’re welcome!
Awesome easy to follow instructions! I work for an aerospace manufacturer and creating these combination charts are a must and also a "wow" factor during meetings :) thank you.
Hi MzHrMny Pomar, thanks for the comment!
I am learning everyday new lessons in Excel, thanks Doug H
Nice video. It helped me a lot. Thanks
Excellent video!
Thank you! Cheers!
This is really useful!!!!!! Hope to learn more chart animation!!!!!
Excellent explanation!!
Thanks for posting.
You're welcome!
Wow great video! Thank you!
Glad you liked it!
Excellent tip. Thank you.
God bless you ! Greathings from Serbia
Hi Wild East, thanks for the comment!
Great. Very clear and useful!
Glad you liked!
Thanks Doug! It was a great great video, to the point and very easy to implement. :)
Hi Apoorva Shetty, glad you liked it, thanks for commenting!
Very useful tech, thank you
Hi Tim Shen, thanks for the comment!
Wow! Very impressive. Thank you for the video.
awasome!!! ... thank you so much for sharing !
Very helpful!
Hi Raymond Vermeulen, glad you liked it, thanks for commenting!
Very helpful video. Thank you for posting.
Doug my teacher yu are my teacher!!!!!😉😉😉 am learning through ur videos
Thanks Bi-Naya# Tube, glad it helped!
Sir,
Very useful!
I wld continue to search for more tips from you.
Tks!
its really dynamic.. Keep it up share more tutorial like this
Glad you liked...thanks!
Thanks for showing this!
Awesome loved it
Thanks...its nice and useful video :)
You are the best! Thank you!
Hi diemcim, glad you liked it, thanks for commenting!
Doug, I think your videos are simply great and very easy to follow. So thanks a bunch, I had done question, is this possible on Power Point 2010 with check boxes, could you make a video.
Thanks for upload ..very useful
Thank you Doug
Very welcome!
Thank you, this helped me a lot.
You're Welcome!
brilliant tick box idea love it Thanks,
really very helpful video. THANKS.
pls upload some more videos of dynamic charts with macros.
Hi Palash Bhattacharjee, glad you liked it, thanks for commenting!
Really dynamic!
Glad you liked!
Thanks a lot Doug
Excellent !!
Amazing... thanks.. it's a great video
+Thushara Indralal thanks for the comment!
Thanks. Useful
I ran across an Excel file that had the similar feature and I wondered how I can create one like that...well, now I know how it is done! :)
nice..good help
Hi Doug, Thanks for this video, it made dynamic chart creation look easy. Is it possible to also make the legend dynamic.
It was a great video. I am so happy that I did it :)
Thank you very much for your efforts
You're welcome!
Muito bom, dica útil, obrigado.
.Hey D, great show there buddy!
It is very useful
Thank You!
You're Welcome!
Thanks!
You're Welcome!
Thank you so much! Amazingly explained! :D
Hi ShayanGaming, glad you liked it, thanks for commenting!
Useful Video , i like the way which he presenting the information
BR
***** Welcome :)
That's gorgeous
Hi MedTube, thanks for the comment!
thank you so much, your voice is so sweet
Cool thanks😊
Hi Lily C, glad you liked it, thanks for commenting!
Thanks , its very helpful.
This is awesome.
Hi Adebo Olusegun, thanks for the comment!
love it...
Could I apply this to the PowerPoint presentation? Thanks in advance
Wow. Brilliant
Hi Syed Muzammil Mahasan Shahi, thanks for the comment!
Doug H ... U r so welcome
hey dude just a question? if it is possible to link this into other workbook or spreadsheet?
Thanks
You're Welcome!
great thanks
You're Welcome!
Thank you for posting this, got anything for Excel 2013?
Thats really nice of you and also very helpful to me when show up the problem in my work. However, When I use the group box I cant group the check box together. Do you know the reason the quick rep for me. Thanks in advance
Awesome.
Thanks. Nice way of presentation. Suppose I paste special this dynamic chart in ppt, will this check box work? (without double clicking the chart and working in the xls)
excellent
Thanks!
Can you also teach this in google sheets since some organization only have access to google suites
Hi Surrya Shovanesh, thanks for the comment; will look into it 🙂
Awesome
great....
Very useful, thank you !
But can i do the same using pivot charts?
It depends on how you use Pivot Charts, but user friendly options include slicers to help filter data. If want to explore slicers I have a video here at th-cam.com/video/jC98mWjI3ZA/w-d-xo.html
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?
For #1, thanks for adding knowledge to the thread! For #2 I'm not sure I understand the question, but if it is keeping the left axis value maximum static, that would be to right click the Y axis, format axis and set it at some maximum value so it doesn't changed on each chart selection.
Yep, thanks Doug. I tried it after I posted the question and, as in your video, if you have 'Auto' set, it'll do dynamic scaling. But, like you said, you can set values to keep the charts static.
Thanks again!
It's possible to combine this with offset function to create an dynamic chart?
You can try it with this scrolling table th-cam.com/video/Z7tdtJsaVUI/w-d-xo.html
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!
Hi Elin Carlsson, sorry I don't understand....but try a post on the mrexcel.com forum!
Hi, Its very nice.. pls suggest how to add value in such type of Graph. when i am adding #N/A is showing after unchecked
pls help
It is a great video. It is helpfull for me. I want to create a dynamic chart in user form VBA EXCEL . I dont know how to do. Please help me.
Sorry don't know VBA that well...
Thanks!
Hi Doug H, is there a way to use this dynamic chart that allows you to change the X axis when you check, and uncheck the checkboxes? Let's say we didn't use data for the 'Years' but instead Product A was 'Vegetables' and Product B was 'Fruit'. If you checked Product A you would see Potato, Corn, Carrots etc instead of 2000, 2001, 2002, and if you unchecked that and checked Product B you would see Plum, Apple, Orange etc. I know the configuration of the table may need to be altered slightly. Does that make sense and could you please do a tutorial of how I could achieve that? I appreciate your tutorials so much and gain so much from them.
PS: I am so sorry that my comment posted so many times previously. I was posting from my phone and it said it was unable to post my comment so I kept trying, only to get on my laptop and see multiple posts - of which I ended up deleting them all and not leaving the original! Fail. ;P
Perfect! Thank you. :)
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
Should work with the right combination of #N/A that the chart will source from
Doug H can please u send me a link for video or a video for that ☺
Appreciate to send me a excel sheet contain me request or short video for my request 2 to 3 minutes for this point only, Thanks A lot,,,,,,,
Though not exactly the same scenario, maybe these video will give some insight = >
th-cam.com/video/6ekd_j0G0b0/w-d-xo.html
th-cam.com/video/taTnVeEQFSA/w-d-xo.html
Thanks my Dear Iam already reviewed this video before but not give me my insight, all on all thank u for your help
awesome
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
don't know about google sheets
Great,,,,,,,,,,,,,,,,,,,
Thanks Hesham Lotfy!
I can see this as helpful in creating a dashboard but not practical if you have to repeatedly set it up again as the data changes. You would have to recreate the logic table, wouldn't you? Maybe the same effect could be achieved with slicers.
Hi Justin White, thanks for the comment!
How do I do the same thing but instead of using check boxes I want to use drop down lists?
Try this video th-cam.com/video/lCsvSdk4Tro/w-d-xo.html
Nice video but no so perfect if you insert chart data labels.
Why not just use Charts("X").SeriesCollection(X).Format.Line.Visible = True or False?
Hi Marek, thanks for the comment!
@@DougHExcel Thanks for the videos I remmeber they helped me alot.
Excellent!!
Thanks Ahsan Abas!