How-to Make a Conditional Column Chart in Excel – REDO

· In a previous post, I showed you how to make a Conditional Column Chart for your Executive Dashboard Templates, but I had 3...

How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart

Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...

3 Ways to Create Vertical Lines in an Excel Line Chart

Sorry I have been swamped on a new project in Australia and Singapore so my posts have been less frequent than I wish.  We...

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...

How-to Create a New York Times Tiger Woods Chart in Excel

In a past article, I posted 2 different ways to make a chart that appeared in the New York Times.  Here is the chart...

How-to Make a Pass Fail Chart in Excel

Last week, I posed a Friday Challenge that was posted in a Q&A for Excel.  Here it is: ***************************************************************** Plotting a line graph to track build...

How-to Make a Dynamic Chart Using Offset Formula

In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables.  This is a very easy...

How-to Connect Gaps in a Line Chart in Excel

When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete.  For instance, you may...

How-to Show Gaps in a Line Chart When Using the Excel NA() Function

In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart.  In essence, he wanted to...

3 Ways to Add a Target Line to an Excel Pivot Chart

Add a Target Line to an Excel Pivot Chart Many Excel users use Pivot Tables and they find it very easy to create a Pivot...
Want to Receive the Next Post?
Join My Newsletter
Give it a try, you can unsubscribe anytime.
Privacy Policy
Subscribe Now!   (Privacy Policy)

Stay Connected!

Get the latest post emailed straight to your inbox!