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