10 different advanced Excel charts: what type of data to use with them, when to use them, and the advantages they provide over traditional charts.
-- LINKS --
DOWNLOAD THE WORKBOOK ► excelcampus.com/charts/10-advanced-charts
*** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM***
excelcampus.com/join-elevate
--
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) excelcampus.com/blueprint ~
~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: excelcampus.com/newsletter/
0:00 Intro
0:58 1. Column Chart with Percentage Change
1:49 2. Conditional Donut Progress Chart
2:22 3. Interactive Histogram with Details
3:14 4. Dynamic Histogram or Frequency Distribution Chart
4:28 5. Annual Trend with Monthly Details
5:39 6. Interactive Waterfall Chart
6:43 7. Variance on Clustered Charts
7:26 8. Actual vs. Multiple Targets Chart
8:05 9. Stacked Bar with Dynamic Data Labels
9:24 10. Comparative Distribution Chart
10:13 11. Bonus: Zoom on Charts Macro
**********
EXCEL FRIENDLY ACCESSORIES WE USE (Affiliate Links When Possible): LOGITECH KEYBOARD
Check out all the tech we use and recommend at excelcampus.com/store
**********
--- Related Content ---
- Progress Circle Chart in Excel: youtube.com/watch?v=KbAmWC2AuSk
- Column Chart That Displays Percentage Change in Excel: youtube.com/watch?v=SRTwzaTRfCc&t=9s
- Actual vs Targets Chart in Excel: youtube.com/watch?v=E5JTaRJ9VpY
- How to Create an Interactive Histogram Chart that Displays the Group Details: youtube.com/watch?v=Z3O7xDCSZBI
Please leave a comment below with info on what type of chart you'd like to see a tutorial on, or explain what type of data you have. Thanks! 🙂
#MsExcel #ExcelCampus
- Get Ahead With These 10 Advanced Excel Charts! ( Download)
- Progress Charts in Excel! 8 Types That Will Help You Get Ahead ( Download)
- 10 Advanced Excel Charts and Graphs (Creating from Scratch) | FREE Excel Course ( Download)
- 25 Advanced Excel Chart Tips and Tricks ( Download)
- Advanced Excel: Using Charts and Functions to See Trends ( Download)
- Build 5 ADVANCED Excel Charts from Scratch ( Download)
- Actual vs Target Charts in Excel: How to make variance charts in Excel with floating markers or bars ( Download)
- 4 ADVANCED Excel Chart Techniques ( Download)
- Master Excel 2024: Advanced Filter, Sort, and Switch Functions for Data Analysis ( Download)
- Quick Excel Mastery: Progress Circle Charts in Just 60 Seconds! ( Download)
- Excel Dashboard Course #15 - 10 Advanced Excel Charts for Dashboards ( Download)
- Pro Excel Chart Tips for Rapid Report Creation! ( Download)
- You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯 ( Download)
- Top 10 Advanced Excel Tricks for Data Analysis | Excel Tutorial For Data Analysis | Simplilearn ( Download)
- Make Impressive McKinsey Visuals in Excel! ( Download)
