Create Thermometer or Progress Charts in EXCEL.
👩💻 In this video, we'll learn how to create Thermometer charts 📊, as they're commonly called. These charts are excellent for measuring progress, advances, (%) spent on a budget, the number of purchase orders completed versus requested, etc. 👍😁
00:00 INTRO
✅ Example #1: Purchase Orders Requested vs. Closed.
01:13 Step 1: Insert a simple Clustered Column Chart.
03:17 Step 2: Overlay both series.
03:53 Step 3: Add a thicker border to the background series.
✅ Example #2: A Company's Annual Budget.
07:19 Step 1: Insert a simple Clustered Bar Chart.
08:49 Step 2: Step 3: Overlay both series.
09:15 Step 3: Add a thicker border to the background series.
11:03 BONUS: Add a data label with the % change.
.
-----------------------------------------------------------
LINKS to the referenced videos:
▶ VIDEO: ADVANCED TRICKS for Charts in EXCEL
• ✅ Masterclass | Trucos Avanzados de Gráfic...
▶ VIDEO: Create a Variation or Comparison Chart in EXCEL
• Crear un Gráfico de Variación o Comparació...
-----------------------------------------------------------
👨💻 If you want to download the video file for practice, download it from the following link:
https://smartprosoluciones.com/como-h...
Did you like it? Support me with your LIKE 👍 or comment. Leave me a comment about what you would like me to teach 👍🤓.
-----------------------------------------------------------
📒 Would you like to know your current level in EXCEL? Take our free TEST:
https://maraton.smartprosoluciones.co...
-------------------------------------------------------------
✅🚀 🅼 🅸 🆂 🅲 🆄 🆁 🆂 🅞🆂
DO YOU WANT TO FINISH CATAPULTING YOUR EXCEL SKILLS 👩🏻💻 👨🏻💻 and STAND OUT FROM THE MASS OF PROFESSIONALS? Great because I'm letting you know you have the option of taking my courses LIVE ONLINE 👍😁.
Visit my academy's website for more information:
https://www.smartprosoluciones.com/
---------------------------------------------------------------------------------------------------------
👨👨👧 LET'S STAY CONNECTED! 😁:
Instagram and Facebook: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
-----------------------------------------------------------------------
💡💻 Get the Microsoft 365 Excel Version:
https://click.linksynergy.com/fs-bin/...
🎥💻 I use this program to produce and edit my videos: https://techsmith.z6rjha.net/c/273772...