Quantcast

How-to Insert Slicers into an Excel Pivot Table

In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post, we explore the...

How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis

In this previous post: Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis I had a fan question - How...

How-to Make an Excel PickList Chart for Multi Years by Month

Here is my response to the recent Friday Challenge on Creating a Chart for Multi Years by Month. You can read more about the original...

Excel Super Bowl Statistics Dashboard

A great big shout out to Don who submitted the best Excel Dashboard of Super Bowl Statistics.   It has a neat design and uses picture...

How-to Use Data Labels from a Range in an Excel Chart

Excel 2013 has some cool features. If you were not aware, here is an awesome Chart Data Label option that you now have when...

How-to Make an Excel Stacked Area Chart Cliff

A while back, I published an article on how to make an Area Cliff Chart. Now this isn’t a standard chart type. If you use the Standard...

How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart

Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...
Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA

Find And Replace from a List of Multiple Emails in Excel without VBA I had a recent request from a friend who needed to Find...
Final Stacked Column Pivot Chart with a Grand Total Line

How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...

Don’s Take on the Better Sales Funnel Chart

I got a positive comment from Don and he liked the Better Excel Sales Pipeline / Sales Funnel Chart. But....he thought it lacked ***flash***! So he...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link