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 Easily Create a Stacked Clustered Column Chart in Excel
Create a Stacked Clustered Column Chart in Excel
There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
Add Vertical Line Between Columns in Excel Stacked Column Chart
Add Vertical Line Between Columns in Excel Stacked Column Chart
In this tutorial, you will learn how to QUICKLY add a vertical line between columns...
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel
Excel is awesome because, even when a certain chart type is not a standard option, there may be...
How-to Close the Gaps Between Chart Series in an Excel Stacked Clustered Column Chart
Many users like to create a chart that Excel doesn’t have as a chart type. It is a combination of a clustered column and...
How-to Setup Your Excel Data for a Stacked Column Chart with a Secondary Axis
Many users have mixed reactions about this secondary axis overlap fix. You can see the post here:
Stop Excel From Overlapping the Columns When Moving...
How-to Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
Friday Challenge – Stacked Bar With Distribution Within a Given Range
Hello everyone. Sorry, that I haven’t presented the solution to last Friday’s challenge yet, but I have been a bit under the weather and...
Case Study Solution – Mom Needing Help on Science Fair Graphs/Charts
Yesterday I presented a case study on assisting a mom in creating a chart for a science fair.
You can read more about it here:
Case...
Friday Challenge Answers – Food Donation Excel Dashboard Chart
Last week we presented a chart challenge to see how you represent Food Donation data.
Don said that we should keep it simple and sent...













