Excel Charts

Excel Charts

Leila Gharani via YouTube Direct link

Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

24 of 42

24 of 42

Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Charts

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Excel Charts & Graphs: Learn the Basics for a Quick Start
  2. 2 How to create a dynamic map chart with drop-down (works with ANY Excel version)
  3. 3 Quick Gantt Chart in Excel (Unusual technique)
  4. 4 Fully Featured Excel Gantt Chart - actual, planned & percentage completed
  5. 5 Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)
  6. 6 Excel Charts: Matrix or Excel Panel Charts - Showing many variables at once
  7. 7 Improve readability of Excel Line Charts: Dynamic Legends in Excel
  8. 8 Excel Advanced Charts: Comparison to Budget, Previous Year and Forecast or Outlook
  9. 9 3 Tips for Impressive Excel Charts
  10. 10 Microsoft Excel: How to Improve your Charts & Tables for Better Communication - Promo
  11. 11 Excel Charts: Visualize your KPI on a map in ANY version of Excel
  12. 12 Excel Charts: Sorted Bar Chart as Alternative to the Pie Chart
  13. 13 Excel Tables: Best Practice to Create Tables for Financial Reporting in Excel
  14. 14 How to Conditionally Format Symbol colors in Excel Tables (without Conditional Formatting)
  15. 15 Excel Tables: Use Smart Conditional Formatting for great table layout
  16. 16 Excel Variance Charts: Actual to Previous Year or Budget Comparisons
  17. 17 Better Excel Variance Charts to show percentage change (Simple & uncommon technique)
  18. 18 Excel Arrow Variance Chart: Dynamic Arrows in Chart to Show Change to Previous Year / Budget
  19. 19 Excel Charts: Total Values for Stacked Charts in Excel
  20. 20 Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability
  21. 21 Excel Charts: How To Show Percentages in Stacked Charts (in addition to values)
  22. 22 How to add series lines / connectors to stacked column charts in Excel
  23. 23 Skip Dates in Excel Charts (ignore gaps in Excel horizontal chart axis)
  24. 24 Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)
  25. 25 Optimized Excel Line Charts: Prevent drop to zero & dynamic Legend positioning
  26. 26 Excel Dynamic Chart with Drop down List (column graph with average line)
  27. 27 3 REALLY Useful Excel Chart Tips You May Have Missed
  28. 28 Excel Column Chart - Stacked and Clustered combination graph
  29. 29 How to create a Step Chart in Excel (that is fully dynamic & easy to read)
  30. 30 Easiest Step Chart in Excel (this trick will surprise you!)
  31. 31 Dynamic WordArt in Excel with Bar in Bar Chart (Info-chart that shows % completion)
  32. 32 Excel VBA: Adjust Fill Color of WordArt with a Macro
  33. 33 Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)
  34. 34 Excel Conditional Bar Chart with Drop-down & Icons (This Chick's Trouble for Excel Hash)
  35. 35 How to Create a Sales Funnel Chart in Excel (Not the "usual" Funnel)
  36. 36 Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts)
  37. 37 Charting Survey Results in Excel (Visualize Employee Satisfaction results)
  38. 38 Progress Circle Chart in Excel as NEVER seen before!
  39. 39 5 Eye-Tracking Discoveries for OPTIMAL Chart Design - Do you use these?
  40. 40 Simple Excel Trick to Conditionally Format Your Bar Charts
  41. 41 How To Create A Histogram in Excel (& change the bin size)
  42. 42 Excel Column Chart | Replicating COVID-19 Overlapped Bar Chart

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.