How-to Build an Advanced Excel Chart

You may want to sit for this. Here is a fun, cool & interactive Excel chart that beats anything you can make with Power BI.
This dynamic scatter plot (made in Excel) explains,
👉 How house prices change with distance from city centre in Melbourne
👉 How many houses are under a certain price point
👉 Visually shows all such houses and tells the story behind them
👉 And it is interactive!
You can create this by combining simple formulas, scroll bar form control and XY charts in Excel. In this video, I explain the full recipe with many handy tips that you can re-use elsewhere. So, pick up your jaw off the floor and follow along. You are in for a wild ride 🚗
📁 Try this yourself, here is the data:
chandoo.org/wp/wp-content/upl...
~
⏱ Video Topics:
==============
0:00 - Demo of the interactive house prices chart
1:00 - Setting up the Scrollbar Form Control in Excel
2:02 - Creating and formatting the XY (scatter) chart
3:28 - Adding the jitter effect
5:08 - Integrating the scrollbar with the chart
7:55 - Storytelling with title & sub-title for the chart
11:26 - Formatting the visual tab
📊 Excel Charting Playlist and Super-hits
=================================
Easy Interactive Chart with Checkboxes:
• Make an AWESOME Dynami...
Waffle Chart with Excel:
• Impress your boss with...
Variance Chart (Budget vs. Actual):
• Make a BEAUTIFUL Budge...
Dynamic Top 5 Chart in Excel:
• Create a Top 5 Dynamic...
Excel Charting Basics + Simple Tricks for you: • Smart Charts for Story...
Advanced Excel Charts Playlist - • Advanced Excel Charts
~
#excel #dataviz

[@DevAnandSingh-kt6fi]

Thank you sir, we are MBA students and we watch your videos in groups to help each other your are working really hard for such great content, Thank you once again.

[@chandoo_]

Wow.. that is amazing to hear. All the best to your group :)

[@komanguy]

Great! People are not aware of excel being so powerful. Thanks for this useful video.

[@behrad9712]

Nice, thank you so much!🙏

[@mansijswarnkar2183]

Amazing - from where you got all these creative inspirations? you are simply incredible Chandoo Garu!

[@vandebharat5921]

Very very beautiful ❤️❤️❤️❤️ Thank you sir, more visualisation like this really appreciated 👍

[@chandoo_]

My pleasure

[@chrism9037]

Nice video Chandoo. I often default to using Power BI for more complex charting but I really like how you used the scroll bar

[@chandoo_]

Glad it was helpful!

[@Robert-hb5tc]

awesome video! -floored by the skill

[@ditabahari5295]

Amazing!

[@johnborg5419]

That was great!!!! Thanks :) :)

[@tnssajivasudevan1601]

Excellent Sir

[@paulmartinlife]

Nice work. Personally, I find mean house price more useful than average.

[@chandoo_]

I think you mean median (excuse the pun)

[@Noob-ng1of]

aren't mean and average like the same thing?

[@paulmartinlife]

@chandoo_ yes, I meant median 😀

[@tazguy371]

@@Noob-ng1of The mean (or arithmetic mean) is a type of average, just as median and mode are.

[@bryan__m]

If only Excel would add a MEDIANIFS formula!

[@martinargimon730]

excellent thanks

[@ericmwangi4309]

Your videos inspire me a lot as a data analyst beginner

[@chandoo_]

Glad to hear that

[@chaitradeshpande7178]

Wow!

[@htoheeb95]

Hi chandoo, Thanks for this video. May i ask why you used the formula U7+U10*U4/100 For the price check

[@NeetSheth]

*THE GOD OF EXCEL* 🛐🛐

[@Bravo_one_two_tree]

Hi. Thx for video. I added new column (price(50k)) and apply a formula nothing chanced. What could be wrong?

[@preetshah3793]

Please make a video on IBM spss

[@goutamnayak5011]

Sir as a Excel export,Can copilot 365 and other ai tools do all type of works in ms Excel Or is it still important to learn ms Excel deeply all functions and advance formulas ??

[@Farhazh]

Hi Chandoo, awesome as always! I just have one question, while adding the percentage why is it that you added separate text box to put % and not changing the source format from number to percentage?

[@chandoo_]

You are welcome. I liked the look when the % sign is smaller than the number itself.

[@Farhazh]

Thanks so much for the clarification, i thought there maybe some logic for not using it directly as a percentage 😅

[@wasimakram3066]

00:01 Create an interactive Melbourne house prices chart using Excel 01:58 Create a scatter plot chart to visualize housing prices and distances from the city. 03:55 Adjust reference and add jitter to improve data visualization 05:51 Building an advanced Excel chart 07:52 Building advanced Excel chart titles and adding formatting 09:47 The average price of the houses is 1.28 million dollars. 11:57 Create text boxes to display title and subtitle 13:52 Add a title and icons to the chart for a visually appealing look Crafted by Merlin AI.

[@jerrydellasala7643]

Note to those using the Beta edition - the "Insert" used in the video to add the scroll bar has moved to the Developer tab. Unfortunately, in my version there are no arrows! ALSO, I decided to try the formula "=COUNTIFS(melb[Price (50k)],"

[@mayuronce]

చందు గారు తెలుగులో కూడా వీడియోస్ చేయండి ప్లీస్ 😇

[@oluwasegunfatoye2347]

Mr. Chandoo, can I use a laptop of 8gb ram, 128gb SSD Hard drive for data analysis

[@akhilgupta2609]

Yes you can. 8Gb Ram is awesome, if you can have a 256Gb SSD it would be great, but if you use a 128Gb SSD also it will work awesome just a small difference.

[@vuminh211]

i cracked excel 2016 on my laptop, will i be able to do this on my excel version?

[@chandoo_]

I don't recommend using pirated Excel. Instead use the free Excel on web and you can re-create almost everything shown in this video (except the form control, which you can substitute with a datavalidation or timeline slicer)

[@b_rizzle4808]

this reminds me that python is coming to excel... any idea when normal 365 users will be able to get it?

[@hinditoystory7108]

can you please share your braces experience? did it help you and also did you face any challenges? Please reply

[@chandoo_]

They are going GREAT! After the first few months, there is no lingering pain, and I am able to eat and sleep better. My teeth have already come to shape and in next 6 months, they will slowly move to even better position. No challenges other than 1-2 painful days after monthly adjustment checkups.

[@hinditoystory7108]

thanks for quick reply@@chandoo_ I have an open bite issue and i am already 39. Doctor suggested for braces but I am not sure because of my age. Also have no idea about the challenges and pain during the journey as it would take 18 months at least. so would you recommend me to go for braces after your personal experience?

[@liila52]

@@hinditoystory7108Hi I am also same as you age and I have large open bite and getting braces tomorrow and I was nervous also getting extraction after two weeks

[@chandoo_]

If you can afford them then I highly recommend them. They are easier to take care of as we tend to be more careful with brushing and cleaning as adults than kids. In most cases, you will get used to them after a few weeks and won't even notice them most of the time. 18 months is goes by quickly too. Good luck :)

[@hinditoystory7108]

thank you so much for your all your help :) @@chandoo_

[@sadianaz9639]

Very difficult for me

[@micharogoz2173]

please dont show this vid in my company

[@PavanMS87]

🤣