Excel Chart Challenge

Friday Challenge: Help! New to Excel! YOY Comparisons

Luckily I was able to help this user, but I think that we can even do more.  Here was the original request: "Help Please! I’m new to Excel charts and I need to chart these...
Network Data Usage Excel Chart

How-to Visualize 17000 Data Points of Upload and Download Times

In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage. With so many data points, it may be best to visualize the data to see what...
Excel Dashboard Friday Chart Challenge

Friday Challenge: What Charts Would You Make?

This Friday Challenge involves Network Data Usage.  You will find over 17,000 data points representing 2 days of network data usage in the linked file. With so many data points, it may be best to visualize...
Add a Target Line to a Clustered Stacked Column Chart

How-to Add Lines in an Excel Clustered Stacked Column Chart

I have posted several Excel chart samples related to Clustered Stacked Column Charts. In case you missed them, you can check them out here:   Excel Clustered Stacked Column Chart Tutorials Recently a user asked me how...
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 in Excel?"  Well there are a few tips and tricks...

How-to Easily Hide Zero and Blank Values from an Excel Pie Chart Legend

If you have ever used a Pie Chart in Excel, then you probably ran into this need. The need to hide Pie Chart Legend entries that are blank or have a value of zero (0). From...
How to Create a Thermometer Goal Chart in Excel

How-to Make a Thermometer Goal Chart in Excel

How-to Make a Thermometer Goal Chart in Excel A friend and co-worker asked me if I had a tutorial on a building a Thermometer Goal Chart in Excel. I realized that I do have one: Related...

Excel Stacked Area Time Chart – Friday Challenge Answer

In our recent Friday Challenge, a user asked this: "This is a scatter with smooth line and markers graph. What I would like to have displayed, is everything above the blue line one colour, between...

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 Chart.  However, Pivot Charts have some limitations.  For instance, Pivot...

Friday Challenge – The Right Graph Style For What I Want to do

A newer Excel Chart creator had this question: "This is a scatter with smooth line and markers graph. What I would like to have displayed, is everything above the blue line one colour, between the...