Archive

Category Archives for "Charts"
22

Column Chart That Displays Percentage Change or Variance

Bottom line: Learn how to create a column chart that displays the percentage change or variance between the columns.

Skill level: Intermediate

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

8

5 Ways to Select Multiple Shapes

Bottom Line: Learn how to select several shapes at once, including charts, slicers, images, etc.  These techniques will help you save time when working with reports and dashboards that contain multiple objects on the same worksheet.

Skill Level: Beginner

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

12

How to Arrange Panel Charts or Shape Grids in Excel with a VBA Macro

Bottom line: Learn how to quickly arrange your charts in a panel chart or shape grid layout with a VBA macro in Excel.  Applies to all types of shapes including slicers, images, charts, etc.

Skill level: Intermediate

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

21

Create Dynamic Pivot Chart Titles with a VBA Macro

Bottom line: Learn how to automatically create more descriptive and dynamic chart titles that display the filter criteria with VBA macros.

Skill level: Intermediate

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

18

How to use Chart Templates for Default Chart Formatting

Bottom line: Learn how to use Chart Templates in Excel to quickly apply formatting and settings to new and existing charts.  Includes instructional videos.

Skill level: Beginner

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

6

Resize & Align Dashboard Elements with Snap to Shape

Bottom line: Learn how to resize & align the charts, slicers, images, and other shapes in your dashboards with the Snap to Shape feature in Excel.

Skill level: Beginner

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

46

Progress Doughnut Chart with Conditional Formatting in Excel

Bottom line: Learn how to create a progress doughnut chart or circle chart in Excel.  This chart displays a progress bar with the percentage of completion on a single metric. We will apply conditional formatting so that the color of the circle changes as the progress changes.  This technique just uses a doughnut chart and formulas.  It is pretty easy to implement.

Skill level: Intermediate

Progress Doughnut Chart with Conditional Formatting 640x360

Continue reading