Not conversion per se, but maybe switching to a different chart by using the camera tool. See ruclips.net/video/nxUTjtFsDMk/видео.html ruclips.net/video/lCsvSdk4Tro/видео.html
@@DougHExcel Thanks for your quick reply! Too bad that your technique does not apply to Pie-Chart! I did try but it only work for one item but not the rest!! Thanks for your share on the camera tool Great!!!
@@DougHExcel The problem that I am having that a Pie Graph only let's me select one Series at a time. I need a pie chart to show % for different months of the year.
Hi , Doug. Very helpful ! Would you know how to select 2 radio buttons at the same time for comparison purpose ? I presume the formula in the dummy table should be adjusted differently ...? Any clue would be very much appreciated.
Nice video. Very well done. Just to show I know more and act like a snob, you could also do it using a simple vlookup in your auxiliary table and hence you can work with only one range for the chart. Rest all will work as you showed. And that way, you can also use the legend. AND - you do not need the group box for the radio buttons to link to the same cell. All radio buttons on the sheet will automatically link to the same cell, unless you have grouped a few of them separately. Kudos for the video mate, it really showed me how to do this on excel. Thanks again...
As long as the chart is tied to the ranges in the table it will update auto-magically. To ensure that is does, use the Table feature. See table feature video ruclips.net/video/Knk_MD_eOpc/видео.html
Wow! Way cool radio buttons! Looks like "Tiles" in Power View!!!
The video was really great and interesting. Thanks for sharing
Excellent tutorial. Thank you so much!!
Hi Christopher Binnie, thanks for the comment!
Many thanks for sharing , i cant thank you enough .
You are very welcome!
Thanks for sharing and showing what happens when there is a mistake and how to correct. we learn from seeing what happens when you miss something.
Wow simply clean and excellent
Hi Ashok Kandukury, glad you liked it, thanks for commenting!
thanks for sharing!
Great Great Great ? Thank you for sharing. I always have a great things with your video.
Great tutorial!! Is it possible to convert to Pie-Chart using the same method? Thank you....
Not conversion per se, but maybe switching to a different chart by using the camera tool. See
ruclips.net/video/nxUTjtFsDMk/видео.html
ruclips.net/video/lCsvSdk4Tro/видео.html
@@DougHExcel Thanks for your quick reply! Too bad that your technique does not apply to Pie-Chart! I did try but it only work for one item but not the rest!! Thanks for your share on the camera tool Great!!!
Great post! Wondering if this is possible also with a Pie Graph?? I'm having issues trying to make it work with a pie graph.
Yes, it should apply to most chart types.
@@DougHExcel The problem that I am having that a Pie Graph only let's me select one Series at a time. I need a pie chart to show % for different months of the year.
@@mauriciocallejo6911 Same here, it only works for one item! Do you have any solution now?
Hi , Doug. Very helpful ! Would you know how to select 2 radio buttons at the same time for comparison purpose ? I presume the formula in the dummy table should be adjusted differently ...? Any clue would be very much appreciated.
This one will probably fit more -> ruclips.net/video/VQj_28PG-gw/видео.html
Nice video. Very well done. Just to show I know more and act like a snob, you could also do it using a simple vlookup in your auxiliary table and hence you can work with only one range for the chart. Rest all will work as you showed. And that way, you can also use the legend. AND - you do not need the group box for the radio buttons to link to the same cell. All radio buttons on the sheet will automatically link to the same cell, unless you have grouped a few of them separately.
Kudos for the video mate, it really showed me how to do this on excel. Thanks again...
Is it possible to have the axis titles change when you select / de-select a range of data?
Hi Ron Jensen, thanks for the comment
great thanks!!!
You’re welcome!
ÇOK GÜZEL
teşekkür ederim
Will it update automatically
As long as the chart is tied to the ranges in the table it will update auto-magically. To ensure that is does, use the Table feature. See table feature video ruclips.net/video/Knk_MD_eOpc/видео.html
How do you add label to each chart? When I add it, the label does not follow each time I changed the radio button.
Go to each chart (via the radio button) to turn on the labels for each. After that it should persist for each chart change.
Super :)
Thanks!
interesting !
lov u
Thanks arkd3um1988!
My boss was verry happy with my work...but we all know who i need to thank :) so thanks again
It's very helpful, So i can't make it's work by pie chart:(
Hi Hanh Bich, thanks for the comment!