fbpx

Effective Charts and Visualizations [Excel & PPT]

Before We Dive In
Introduction and scope
DOWNLOAD these practice files first
Getting Started: Hidden Tricks for Common Charts
Choosing the right charts for your message
Customizing chart properties [a look at column charts]
Visualize trends with line and area charts
Show % contribution with doughnut charts
Creating and customizing a bar chart
Highlight lowest and highest sales month in a column chart, dynamically
Add a target or benchmark line to a chart
Multi-category axis (Two-Level Axis Labels)
Grab Attention with Non-Standard Charts
Actual vs Plan: Bar-in-bar chart
Conditional formatted variance bar/column charts
Cumulative actual vs budget line charts
Magazine-style KPI Ring charts
Fragmented ring chart
KPI progress bar chart
Stylish pie visualization: Not your usual pie chart
Bullet-proof way to create a waterfall chart for all versions of Excel
Waterfall chart using a stacked column chart
Waterfall chart for excel 2016 and higher versions
The right way to create a thermometer chart
Index charts: Why you should start using them
Adding Interactivity to Charts
Using drop-down lists for dynamic charts
Interactive charts using combo box form controls
Dynamic charts using option buttons
Create Visually-Rich Tables using Conditional Formatting
Evaluate performance with icon sets (traffic lights indicators)
Conditional formatting colour scales (heat maps)
The elegant waffle charts using CF
Visually-Rich Tables using Custom Number Formats & Special Fonts
The basics of Custom Number Formatting: The logic
YoY growth rates using custom number formats and symbols
Scaling numbers with CNFs e.g. 3,724,271 to 3.72M
Custom format chart data labels
In-cell charts using the REPT function
Up/Down arrows using “Wingdings 3” font
S06 Save Time with Branded Corporate Themes & PowerPoint Hacks
Create custom theme: Retrieve in Excel, Word & PPT
15 hacks to speed up your PPT designs
Previous Lesson
Next Lesson

In-cell charts using the REPT function

Effective Charts and Visualizations [Excel & PPT] In-cell charts using the REPT function
Previous Lesson
Back to Course
Next Lesson
small_c_popup.png

Join the Waiting List. Enjoy 50% OFF on launch

Excel Dashboards Course

small_c_popup.png

Join the Waiting List. Enjoy 50% OFF on launch

Advanced Excel Formulas for Faster Reporting!