Chart
Stop Excel Overlapping Columns on Second Axis for 3 Series
If you have 3 series in an Excel Column Chart and move one to the Secondary Axis, learn the trick on how to Stop Excel Overlapping Columns on Secondary Axis
EXPLORE THE LIBRARY
Tag: File Download
Array
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that criteria. Three posts ago, you received a challenge
Chart
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save trees by reducing their usage of paper in copiers and
Calculated Item
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 can you do this same type of Pivot Chart but
Challenge
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 i
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 be
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 Rec
Chart
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 to create this t
Chart
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 this: To this: In
Chart
How-to Make a Thermometer Goal Chart in Excel
Learn how to make an awesome Thermometer Goal Chart in Excel that you can use to track sales goals and other goals of your choosing.