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 Center Excel Clustered Chart Columns Over Horizontal Category Labels
When you have several series
in one chart and only one of those series appear per Horizontal Label Category, you probably want to center the...
How-to Fake an Excel Chart Data Table
Fake an Excel Chart Data Table
Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...
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 Connect Gaps in a Line Chart in Excel
When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete. For instance, you may...
Friday Challenge: Help! New to Excel! YOY Comparisons
Luckily I was able to help this user, but I think that we can even do more. Here was the original request:
"Help Please! I’m...
Friday Challenge: Excel Step Chart Automation
Yesterday, I posted the a demonstration on how to make a Step Chart in Excel.
You can check out that post here:
How-to Easily Create a...
How-to Make a Weekly 24 Hour Time Worked Gantt Chart in Excel
I have seen many questions where an Excel users want to know more about how to create a Gantt Chart using Time instead of...
How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)
Sum Excel Worksheets Technique
Why haven't I known about this simple Excel technique before now?
Maybe you were aware how you can easily Sum Excel Worksheets...
Friday Challenge – Recreate this WSJ Chart
I thought I would give you all something to do before we finish the final posting on Excel Chart Sheets.
So I have been traveling...