Archive

Category Archives for "Charts"
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

11

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

20

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

45

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

16

The NBC Olympic Commercials Dashboard

Olympic Commercials Dashboard Cover wt 640x360

I love watching the Olympics.  It’s cool to see the best athletes in the world compete in fun, weird, and exciting sports.  And I’m always amazed at how close their results are.  Gold medals are often decided by a hundredth of a second.

As my wife and I started watching the Olympics on TV last week, we quickly noticed that there were a lot of commercial breaks during NBC’s nightly prime time coverage (NBC is the TV network that broadcasts the Olympics in the U.S.).  It seemed like there was a commercial break every 5 minutes.  We started wondering how many commercials we were watching.

So the Excel geek in me had to investigate…

Continue reading