How-to Build an Advanced Excel Chart @chandoo_
How-to Build an Advanced Excel Chart  @chandoo_
Uploaded October 2023 | Updated November 2026, 23 hours ago
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/uploads/2023/10/melb-housing-data-raw.xlsx


~

โฑ 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:
youtu.be/L3WFN0bGv8I

Waffle Chart with Excel:
youtu.be/y8CXwOaMrdE

Variance Chart (Budget vs. Actual):
youtu.be/REpNnsdHxlY

Dynamic Top 5 Chart in Excel:
youtu.be/Gx9ZVlGkbOk


Excel Charting Basics + Simple Tricks for you: youtube.com/playlist?list=PLmejDGrsgFyBi4uTM0yTHZdw97cgg5Vnq

Advanced Excel Charts Playlist - youtube.com/playlist?list=PLmejDGrsgFyDsYuGNBBp0Des1WbXMcQdh

~

#excel #dataviz
How-to Build an Advanced Excel ChartHow to set up and use Calculation Groups in DAX | Power BIDENSE Rank Excel FormulaPower BI Dashboard Makeover - 5 IdeasAll Unique Names with One Excel FormulaExcel SEQUENCE Function: 5 Genius UsesThe Secret VLOOKUP Trick that Lookups Multiple Sheets ๐Ÿš€10 Advanced XLOOKUP Tips & TricksHow to make an employee time tracker with Excel [Easy setup]This formula changes how you make dashboards [TOPN in One Cell]Dynamic Moving Average with Excel OFFSETWhats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?
Chandoo |

How-to Build an Advanced Excel Chart

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER