How to make a sexy interactive chart slider thingy in Excel?

[@daveblake6407]

A neat trick, I think with a little bit of VBA you could change the scroll bar, to horizontal Spin buttons and make it so when the spin button reaches it's max value, it could be set to one on next click. You would then have a true "chart carousal". The one change i would make to the example in the video is that if on chart 5, only 6 and 7 would appear to the right, if on chart 6, then only show 7 to the right, with the current setup it implies to the user that if they are showing chat 7, right clicking the scrollbar would then show chart 1, which isn't the case and may lead the user to think it is broken.

[@chandoo_]

Good ideas Dave...

[@greggoodman3520]

I miss working with Excel every day! This would be the kind of thing I could have used when I was a contractor on an AF Base doing telephony reports instead of that insipid speedometer chart my boss wanted me to create. Excellent explanation and idea!

[@ankursharma6157]

AMAZED! Beyond Imagination!! Thank You 🙏

[@julialewis8794]

This is beautiful and your explanation makes it seem so simple. I can't wait to try it out!

[@chandoo_]

Have fun!

[@musicalwanderings7380]

Pedhannaa..!!! Meeru awesome anna!

[@michaelbrown8821]

Excellent Chandoo! Maybe it could be called an Interactive Slide Carousel?

[@tubeampsrule1]

Interactive Chart Slider Thingie is actually the correct name :D great work!

[@chandoo_]

ICST for the win... 🤩

[@ApexTrainingLLC]

Chandoo this is outstanding. Great work. Loving your channel!

[@chandoo_]

Glad you enjoy it!

[@Su-ec7pj]

Cool chart. Thanks for the instruction. :)

[@rencyl5611]

I was looking for something like this. thanks for sharing this cool video 👍🏻

[@chaitanyamuttanapalli3264]

Looking forward to use it in my real scenario!! Really interesting technique

[@TudocomExcel]

Cool idea! I loved it!

[@lakshmipathiganesan6332]

Thanks for sharing an informative chart. One request is probably, it could have been even better had you explained right from scratch as to how you arrived the "Selected Chart" as I could see some formulaes are there especially after the timing 9.14.

[@pravinpathade3237]

Thanks sir

[@wayneedmondson1065]

Hi Chandoo.. very cool and creative technique. Makes a dashboard or live presentation so much more engaging. Thanks for sharing. Thumbs up!!

[@chandoo_]

My pleasure 😊

[@ztawsg]

Super helpful. Its not so easy to implement for me though. Insert picture as a linked cell option is not showing for me in excel 365 for home users. Could you suggest a workaround please?

[@kingparc]

very nice. Thank you Chandoo

[@entertainmentgalaxy971]

superb. thanks for sharing

[@bhaiyyu]

Absolutely fantastic!

[@mlspradeep]

Loved it ❤️, thank you, it so beautiful, I think it blow away when we present them in office Thank you

[@briandennehy6380]

Tremendously clever!

[@rajanghadi2337]

You are awesome. I could have even done this. But difference is I can see it possible only after you do it. It means that your imagination power makes difference. I don't know what to say about you more.... Great.

[@chandoo_]

Thank you for the love. I had lot's of fun toying with this idea.

[@dipak016]

Loved it

[@dgitson]

very nice, creative visualization

[@chandoo_]

Thanks...

[@FaysalEasyExcel]

it's really bold and beautiful

[@anilkumarkarimbanakkal5043]

Very interesting... Super like!

[@chandoo_]

Thank you! Cheers!

[@mirza30101980]

very creative... you can call it a Chart Carousel

[@catchagoat]

I love the outcome of the above video. So I thought I would give it a go. My problem is that when I put a chart in B2 the name box shows Chart 1 this then stops me from converting to a picture, whereas on the video it switches very easly from Chart 1 to B2 when you move the curser. What am I doing wrong?

[@maniyadav5389]

Awesome idea.... You rock Bro

[@rajanghadi2337]

"Not sure what to call this". Let me give name: IC Chart: Interactive Chandoo Chart.

[@agnelosteve]

Very cool. Thanks a ton!

[@brucewayne567]

This is really cool. Can we also control these charts using a slicer?

[@chandoo_]

You can... I would use a slicer with just buttons instead of text on it. Something like this: chandoo.org/wp/use-slicers-as-selection-mechanism/

[@abrarsaad2254]

Great Chart! If I have slicers added to the chart, can it keep the slicers with the charts?

[@chandoo_]

Yes you can! Give it a try...

[@ganeshwarraokorlam4831]

This is really amazing sir..super amazing..let me know how can I share some of my work as well and get some awesomeness added to it..:)

[@chandoo_]

Thanks Ganeshwar... Not sure what you mean by "Share my work" but you can watch other videos on charting topic and improve your skills. Here is my playlist - kzbin.info/www/bejne/rHzCgaaNYrd4Y8k

[@ganeshwarraokorlam4831]

@@chandoo_ thanks Chandoo garu for your reply..just wanted to know if I can have a email ID where I can send some of the dashboards which I prepared and seek some help to either improve it or to reduce the size of the file without disturbing the content in it .. I'm following you on your channel and honestly learning some real good techniques..thank you guruji for all the awesome contents you shared :)

[@drkesavsarma_singer]

Anna, freelance data analyst jobs unte, Hyderabad or India lo...work from home laga...links description lo pettu please...

[@varunagrawal8064]

Great video! however there is a typo -- *compared

[@Joshi7681]

Amazing 😊

[@chandoo_]

Thanks 😄

[@Normambo]

Chandoo you're a genius. Great knowledge of Excel and great creativity...what a great mix!!! You're the best!! Norm from Montreal, Canada

[@chandoo_]

Glad you like it!

[@shivamsingla275]

Please create new dashboard like same this one....

[@pravinpathade3237]

What if all chart size is not same ? How to keep all chart size same , can you please help me with this

[@chandoo_]

This method works best when all charts are same size. If not, you can still place them in cells, but make the cells all equal sized. You can centre align the chart, so it doesn't look weird when showing up on the slider.

[@VivekKumar-vp4no]

You should have showed how to create names ranges otherwise it’s of no use

[@chandoo_]

You can create named ranges from Formula ribbon.

[@m.ahsaniqbal3218]

Nice attempt but bit difficult for users to understand

[@chandoo_]

Hi Asham… Thanks for the comments. This is not meant for beginner users at all. But once you are making interactive charts or dashboards, you can easily build something like this too.

[@m.ahsaniqbal3218]

@@chandoo_ I know that it was for advance users but you made it so nicely and I liked it