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
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 make an employee time tracker with Excel [Easy setup]
๐ฅCheck out Connecteam ๐ https://connecteam.cc/3QSAjlQ
~
Recently I needed to make a timesheet solution for my clients. I used Excel 365 with forms to create a quick & elegant application. It works on phones, web browsers and PC. You can track shift information and consolidate the data at the end of month for payroll processing.
In this video, let me present you with the solution and approach I took.
For an easier and error proof solution, do check out the sponsor of this video Connecteam here - https://connecteam.cc/3QSAjlQ
~
Timestamps for the video:
0:00 - Demo of my time tracking app
1:06 - Creating the app using Excel on web
1:52 - Setting up the data entry form
3:45 - Adding Branching Logic to show different options based on the data entered.
4:32 - Saving and publishing the form (app)
5:30 - Testing our app
8:12 - The problem with our solution
8:45 - A better time tracking solution (with Connecteam)
~ How to make an employee time tracker with Excel [Easy setup]](https://i.ytimg.com/vi/ZJLYMYhtDRc/mqdefault.jpg)
![This formula changes how you make dashboards [TOPN in One Cell]
TEXTJOIN magic for your next dashboard This formula changes how you make dashboards [TOPN in One Cell]](https://i.ytimg.com/vi/Zj4tQP-Cptc/mqdefault.jpg)

![Whats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?
Do you wonder what is the difference between a data analyst, engineer and scientist is? In this video, let me explain what these 3 roles are, what skills you need to get in, how the career path looks like, what is the typical salary and how the work feels. LETS GO!
โฑ IN THIS VIDEO:
0:00 - Data Engineer vs. Data Analyst vs. Data Scientist
0:35 - The rules
1:08 - What they do? DE vs. DA vs. DS
4:07 - Skills you need to be a Data Engineer
5:38 - Skills needed for Data Analyst
6:56 - Skills for Data Scientists
9:01 - Salaries for Data Engineer vs. Data Analyst vs. Data Scientist
11:24 - Career pathways for Data engineer / analyst / scientist
14:11 - People you work and how the work looks like
16:08 - Getting the skills
๐ WANT MORE?
If you want more, consider my paid courses. They are the best in the world when it comes to explaining complex data concepts in lucid and practical terms. Check out the courses using the links below and sign up today.
Essential Data Skills with Excel - https://chandoo.org/wp/excel-school-program/
Essential Data Skills with Power BI - https://chandoo.org/wp/power-bi-course/
๐บ DATA PLAYLISTS
Data Analyst vs. Business Analyst - What is the difference? - https://youtu.be/pIbL4aSUIas
Tech skills needed to be a data analyst: https://youtu.be/R3bZ0LLv3Fk
Data Analyst 3-month roadmap: https://youtu.be/x0Cd4TTOgwI
Day in the life of a Data Analyst: https://youtu.be/Lc55Y7Ai23Q
Top 10 Data Analyst interview questions: https://youtu.be/MX6Ee_ubE1s
7 critical mistakes to avoid in Data Analyst interviews: https://youtu.be/f7lBYh1_9BQ
5 Skills you need to be a GREAT data analyst: https://youtu.be/gVr9f1GJdZc
[Playlist] Data Analyst Skills: https://www.youtube.com/playlist?list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
[Playlist] Data Careers, Interview and Job Prep: https://www.youtube.com/playlist?list=PLmejDGrsgFyAw9Qya6SgrXfcfKCn7Va_D
~
#dataengineer #datascientist #dataanalyst
~
Data analyst: The glass is 50% full ๐ฅ
Data scientist: The glass is over fitting the water ๐
Data Engineer: Somewhere a pipeline must have broken. Only half the water is loaded ๐ค Whats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?](https://i.ytimg.com/vi/ZyRH6FMcVlw/mqdefault.jpg)