Uploaded April 2025 | Updated November 2026, 3 days ago
Need to compare Male vs. Female values? Use this cool interactive technique to impress everyone in the next meeting.
πSample file: chandoo.org/wp/wp-content/uploads/2025/04/male-vs-female-chart-demo.xlsx
π₯Adv. Excel Course: chandoo.org/wp/excel-school-program
π€― Things you will learn in this video:
βοΈ How to set up Male & Female "stencils" in PowerPoint
βοΈ Using XLOOKUP + Data Validation to create a dynamic chart in Excel
βοΈ Axis formatting tricks to get the scaling right
πΊ Other Charting Videos You WILL Enjoy:
Colum Chart with Totals - youtu.be/IcbS1E-7FGA
TopN Chart in Power BI - youtu.be/uQV5MP_THfA
Map Charts in Excel - youtu.be/qNNn5uiZxOE
Variance Charts in Excel - youtu.be/REpNnsdHxlY
Clickable Chart in Excel - youtu.be/L3WFN0bGv8I
#excel #chandoo #charting #dashboards
Need to compare Male vs. Female values? Use this cool interactive technique to impress everyone in the next meeting.
πSample file: chandoo.org/wp/wp-content/uploads/2025/04/male-vs-female-chart-demo.xlsx
π₯Adv. Excel Course: chandoo.org/wp/excel-school-program
π€― Things you will learn in this video:
βοΈ How to set up Male & Female "stencils" in PowerPoint
βοΈ Using XLOOKUP + Data Validation to create a dynamic chart in Excel
βοΈ Axis formatting tricks to get the scaling right
πΊ Other Charting Videos You WILL Enjoy:
Colum Chart with Totals - youtu.be/IcbS1E-7FGA
TopN Chart in Power BI - youtu.be/uQV5MP_THfA
Map Charts in Excel - youtu.be/qNNn5uiZxOE
Variance Charts in Excel - youtu.be/REpNnsdHxlY
Clickable Chart in Excel - youtu.be/L3WFN0bGv8I
#excel #chandoo #charting #dashboards







![How many days overlap between two projects [Excel Formula Magic]
Find out quickly how many days both projects overlap using this elegant and simple Excel formula How many days overlap between two projects [Excel Formula Magic]](https://i.ytimg.com/vi/EqALWpxps0I/mqdefault.jpg)

![How to use Power BI Visual Calculations - Easy Explanation [DAX Tricks]
Power BIs new Visual Calculation feature allows us to do advanced business logic and analytics without the need for complicated (and often messy) DAX. In this video let me demonstrate the power of visual calculations with a cool month on month comparison chart.
Learn how to build report and perform data analysis from scratch, making your data visualization more impactful.
In the video:
0:00 - Demo of Visual Calculation driven sales report
0:25 - Data model for the report
0:50 - Creating the line chart
1:50 - Creating your first visual calculation in Power BI
3:40 - Converting the line to combination chart
4:30 - Fixing the first value in the chart (to blank)
6:15 - Dynamic coloring of columns - positive is green, negative is red
7:40 - Adjusting the axis scaling issues (advanced concept)
9:30 - Adding Axis Max as a measure for dynamic axis scaling
#powerbi #visualcalcs How to use Power BI Visual Calculations - Easy Explanation [DAX Tricks]](https://i.ytimg.com/vi/FCAWIHlknQI/mqdefault.jpg)
