Turn Business Data Into Insights.

Start here 

Grant instant access to learn 30+ impactful Excel chart tips and tricks with all practice files for FREEYou'll also receive emails to discover the Excel Analytics OS Course.

 

SLW#032: Spice Up Your Data Charts! 📊

weekly newsletter

Want to make your charts look cool? This week, let's talk about Conditional Doughnut Charts. Whether you love Excel or just want to make your data look awesome, this is for you!

Here's the easy way:

  1. Find the Remainder: Start by putting in a percentage. Then, do some math (1 - actual %) to find the extra bit.

  2. Use Simple Formulas: Keep it easy with three formulas for three stages (Good, Normal, and Bad). Just use the IF formula to make things fancy.

  3. Make the Doughnut Chart: Put all those formulas into a doughnut chart. It looks cool and shows your data in a fun way.

  4. Add Colors: Make it pop! Choose colors for each part of the chart, and it'll look amazing.

Now, the fun part – try different percentage values in the input cell. Easy, right?

👉 CHECK OUT THE COOL DOUGHNUT CHART

Not feeling like an Excel pro yet? No worries! If you want to get really good at Excel for business stuff, check out our Excel Analytics OS course. Click below to learn more:

🚀 JOIN EXCEL ANALYTICS OS COURSE

Let's make your charts awesome! 

 

That's all for this week.

See you next week.  

✂️-----------------------------------

Whenever you're ready, here's the best way I can help you:

  1. Excel Analytics OS for business professionals
  • Signature course: Excel Analytics OS  (121 short lessons, 8 modules)
I Help You Master Excel for Business Analysis in Just One Course!☀️ Become a Data-Driven Pro. Start Now!

Get 30+ Charts Power Tips for FREE!

Learn 30+ impactful tips and tricks with all practice files. Power up your Excel Chart skills in 30 mins. You'll also receive emails to discover the Excel Analytics OS Course. Many people love it.