Turn Business Data Into Insights.

Start here 

Grant instant access to learn 50+ impactful Excel Analytics TIPS with all practice files for FREE (XLOOKUP + Functions + Charts + Conditional Formatting + PivotTable + Shortcuts). You'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)
Explore the course with SPECIAL OFFER TODAY!

Get 50+ Excel Analytics TIPS for FREE!

Learn 50+ impactful Excel Analytics TIPS with all practice files (XLOOKUP + Functions + Charts + Conditional Formatting + PivotTable + Shortcuts). You'll also receive emails to discover the Excel Analytics OS Course. Many people love it.