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...
What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV...
Recently during a Project that was using Salesforce.com,
I created a custom report and then exported the results to Excel. This report looked and...
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...
Friday Challenge – Part 2 Removing Gaps from a Clustered Column Chart
Okay Excel Fans, in a previous challenge, we had a problem that we solved for a specific data set. We wanted to remove white...
Understanding How-to Make a Step Chart in Excel Using Index and Match Functions
Here is a quick demonstration on the technique that Peter used for his Step Charts:
Learn More about the Challenge HERE
To try it yourself as...
How-To Copy an Excel Chart on Same Worksheet with a New Data Reference
Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another...
How-to Easily Create a Step Chart in Excel
You might be asking yourself, “What is a Step Chart?”
You have probably seen one, but didn’t know that it is called a step chart.
Here...
Add Multiple Percentages Above Column Chart or Stacked Column Chart
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart. You can see the...
Excel Clustered Column Chart Conundrum
Many, many, many Excel users post this problem in user forums. And this one always throws me for a loop and takes me time...
How-to Fix an Excel 3D Chart so that it Matches the Gridlines
While working for a company that paid bonuses, the Financial and Human Resources team sent out a chart showing how close we are to...