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...
Excel Goal Chart Filling a Bottle of Soda
In a previous post, and one of my favorites, I showed you a unique company goal chart using a beer mug instead of a...
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...
Soap Story Dashboard
I am traveling about 100% of the time for my current job. So I spend many more nights in a hotel room than my...
Peter’s Friday Challenge Answer–SEO Keyword Chart
Check out Peter’s answer to the challenge.
This very creative stacked column chart that uses a few really cool techniques like:
1) Picture fill and
2) Custom...
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...
Create a Vertical Line Between Columns in Excel Using Error Bars
Create a Vertical Line Between Columns in Excel Using Error Bars
Thanks to Leonid (a super fan) for advising me on another and possibly better...
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...
How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component
Time for some beer and Excel. Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...
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...














