×

Excel Charts

Build A Tile Grid Map of The United States In Excel

Build A Tile Grid Map of The United States In Excel

What Is a Tile Grid Map? A tile grid map is a visualization technique used to represent data related to...

Dynamic Array Formula Spill Ranges With Charts

Dynamic Array Formula Spill Ranges With Charts

Linking Dynamic Array Formulas into Chart Series With the introduction of Dynamic Array functions in Excel, your spreadsheets can now...

Add Total Value Labels to Stacked Bar Chart in Excel (Easy)

Add Total Value Labels to Stacked Bar Chart in Excel (Easy)

Stacked Bar Charts Missing Total Labels In Excel Unfortunately, Microsoft Excel cannot insert data labels at the top of vertical...

How To Build Waterfall (Bridge) Charts In Excel

How To Build Waterfall (Bridge) Charts In Excel

Waterfall/Bridge charts are commonly used in the finance world to show up and down variances between two periods of time....

Add Vertical Lines To Excel Charts [Best Way!]

Add Vertical Lines To Excel Charts [Best Way!]

There are a few creative ways to add a vertical line to your chart bouncing around the internet. If you...

How To Create Excel Progress Bar Charts (Professional-Looking!)

How To Create Excel Progress Bar Charts (Professional-Looking!)

Creating A Progress Bar In Excel Progress Bars are simple graphics that can be quite visually powerful by instantly providing...

Create A Bar Chart With Separate Positive And Negative Colors

Create A Bar Chart With Separate Positive And Negative Colors

Our goal as analysts is to tell a story with our data and it is a well-known fact that data...

What Is A Waterfall (Bridge) Chart

What Is A Waterfall (Bridge) Chart

What Is A Waterfall Chart? The main goal of a Waterfall chart is to walk the audience through how one...

Scroll To Chart Based on Form Control Combo Box Selection

Scroll To Chart Based on Form Control Combo Box Selection

In my previous post VBA For Excel's Form Control Combo Boxes, I showed you all the different actions you can...

Hiding A To-Date Column When Reporting Month or Quarter End Results

Hiding A To-Date Column When Reporting Month or Quarter End Results

The "To-Date" Column I was first introduced to this concept a few years ago when I first started working in...