Is it Possible to make this Excel Column Chart?
I saw this seemingly simple question from an Excel user but I spent a long time trying to figure it out without much success.
Can...
Tips and Tricks – Longer Legend Color Bars in Excel Charts
Here is a real quick tip that you may want to learn when using Excel. This tutorial will help you apply this technique to...
How-to Put Percentage Labels on Top of a Stacked Column Chart
There are times when you are creating your Excel Dashboard Design that you desire something that does not come naturally with the Excel Tools...
Friday Challenge Answers: Year over Year Chart Comparisons
Thanks for the submissions for the Friday Challenge.
You can get the sample data and chart request here: friday-challenge-help-new-to-excel-yoy-comparisons
Here are some other submissions:
A) In 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...
Weird Excel Charts
Have you ever seen a chart or graph like this in Excel?
I created this chart using Excel the other day.
It IS one combined chart...
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...
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...
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
How-to Make Longer Legend Color Bars in an Excel Chart Video Tutorial
Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph. However, this...