Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Progress Circle Chart in Excel as NEVER seen before!
Play lesson

Excel Charts - Progress Circle Chart in Excel as NEVER seen before!

5.0 (2)
14 learners

What you'll learn

This course includes

  • 9 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

🔥 Create charts that wow your audience. Learn the secrets now—start today! 👉 https://link.xelplus.com/yt-g-donut-charts-course Want to move beyond standard Excel visuals? This tutorial demonstrates how to transform a basic donut chart into a sleek, rounded progress circle—perfect for modern KPI dashboards and project trackers. Learn how to create a stunning doughnut chart in Excel with this easy-to-follow video. Whether you're an Excel beginner or a seasoned user, you'll find valuable tips to enhance your charts. ⬇️ DOWNLOAD the workbook here: https://www.xelplus.com/excel-progress-circle-chart/#download What You’ll Master in This Tutorial: - Dynamic Linking: How to embed text boxes directly into chart objects so they move and scale together. - Chart Layering: The secret to combining different chart types (Donut + Scatter) on a single set of axes. - Marker Logic: Using built-in markers to cap off data series for a high-end UI/UX feel. - Dashboard Math: A breakdown of the SIN and COS formulas needed to position markers at any percentage on a circle. Two Unique Methods: Discover not one, but two methods to create doughnut charts with smooth, rounded edges. Both methods are explained in detail, ensuring you can follow along regardless of your Excel experience. 🎓 500,000+ professionals trust our courses—start your journey here 👉 https://link.xelplus.com/yt-d-all-courses This Progress circle chart infographic is different to what you've seen before. Just like the other progress circle charts it uses the doughnut chart as the basis. A text box is placed in the middle of the progress chart (I will show you an Excel chart trick to embed the text box inside the chart object). The value of the text box is connected to the percentage completed value which is input in a cell. 00:00 Why standard Excel donut charts look boring 00:42 Method 1: The "Border Trick" for fast rounded edges 02:02 Professional Tip: Embedding dynamic text inside charts 03:01 Adjusting donut hole size for a minimalist look 04:57 Method 2: The "Advanced Way" for perfectly circular edges 05:30 Using Sine and Cosine functions to map circle endpoints 06:50 How to combine Donut charts with Scatter Plots 08:24 Scaling and aligning axes for pixel-perfect markers 09:50 Final Test: Making your progress chart fully dynamic What makes this chart different to the rest? It's a small design tweak that makes THIS progress circle chart look more professional. This chart comes with ROUNDED EDGES. This seems like a small tweak, but there isn't a simple option in Excel to get the inside shape have rounded edges. In this video you'll find two versions to create this Excel progress chart infographic with rounded edges (or the doughnut chart with rounded edges): Version #1 (by me) - It requires a simple tweak to the border of the chart. This brings us halfway there but it doesn't give the professional look we're going after. Version #2 (by Sam Dekoven): This version has perfectly rounded edges for the doughnut chart and it uses a smart technique which combines a scatter plot series with the doughnut chart (together with the SIN COS and PI Excel Functions). Many thanks to Sam for sharing his version with all of us! LINKS to Excel infographic chart playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyw08u-MZm4ROnB3J0gRlsop Advanced Chart Techniques: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

FAQs

Course Hive
Download CourseHive
Keep learning anywhere