Stacked bar chart with data from multiple columns – How would you do it?
Hello everyone! Thanks for being a fan. I am such a fan of Excel, that meeting MrExcel this week threw me off my schedule. ...
How-to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart
Here is a very simple solution to a common Excel Charting question when a user wants to graph “Three sets of data criteria on...
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...
Friday Challenge – Create a Percentage (%) and Value Label within 100% Stacked Chart?
First I want to say I am sorry to those waiting to see the dynamic chart scroll bar tutorial. My project launched this week...
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...
Budget Analyst Question: My Answer
Last week I posted this:
Budget Analysts might be asked by their executive team, managers or co-workers.
Question Title: Bar Graph Below the Line
I need a...
Creating Excel Stacked Column Chart Label Leader Lines/Spines
In my last post, I showed you how to create a Brace/Curly Bracket/Mustache InfoGraphic type grouping in an Excel Stacked Column Chart.
You can check...
How-to Make Conditional Label Values in an Excel Stacked Column Chart
Recently I was thinking that sometimes when you make a Stacked Column Chart in your Excel Dashboard, you may want to hide some of...
How-to Make an Excel Chart with 3 Different Column Widths (Bullet Chart Option 2)
In are recent post, I showed you how to create a Bullet Chart in Excel. Pete, then sent me another way to create a...
How-to Make an Excel Bullet Chart
Executives and managers love to see gauge charts in their Excel Dashboards. However, gauge charts may confuse or mislead the dashboard readers. For instance,...
