In this video, I will show you how to use interactive controls (such as a scroll bar or a checkbox) and make the charts dynamic.
These can be useful as it allows the user to automatically update the chart based on the selections.
The following examples are covered in the video:
— Bar chart with scroll bar and checkbox
— Scatter chart with Combo Box
✅ Download File –
☕ If you’re the videos useful and would like to support me, you can buy me a coffee –
Free Excel Course (Basic to Advanced) –
Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Nice tutorial. Thank you Summit
sumit sir vaake me maan gye guru aapko khtrnaak cheej sikhne ko mili apki videos se power bi pr video bnao sir basic se leke with formula
You mentioned at around 19:15 that one can change colour of Revenue % based on value being True or false in the cell. Is there any way to change colour of shapes based on cell value without VBA? I know it possible if it was pasted as linked picture, but that limits the options on shapes.
I have a question…why did u take range F4. Though it was blank