How-to Make an Excel Stacked Area Chart Cliff
A while back, I published an article on how to make an Area Cliff Chart.
Now this isn’t a standard chart type.
If you use the Standard...
How-to Add Specific RGB or HSL Colors in Your Company Chart or Dashboard
Do you want your Excel charts and dashboards to really stand out at your company?
Well then you should start using custom colors in all...
How-to Create a Combo Line and Column Pivot Chart
Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts. I recently saw a post asking for this help:
"Please...
Create a Excel Gantt Chart to Display a Music Festival Band Schedule
Here is Pete's answer to the recent Music Festival Schedule Challenge.
In this video, see how he used Index/Match functions as well as a helper...
Don’s Macro Enabled Friday Challenge Answer – Music Festival Schedule Excel Chart
In our last Friday Challenge, we wanted to see if you can make a Music Festival Schedule in an Excel Chart.
There were 2 questions. ...
Friday Challenge – Create a Chart to Display a Music Festival Schedule
Here is an interesting question that I saw and I thought I would present it as the next in the series of Friday Challenges.
This...
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...
How-to Easily Make a Dynamic PivotTable Pie Chart for the Top X Values
I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5...
Terrible Chart Tuesday – Leader Lines
So in yesterday's post, I showed you that in Excel 2013, you can now add leader lines to your Line Chart. They are not...
New Chart Label Leader Lines Available in Excel 2013
Did you know that you can now add Leader Lines to your Excel Charts in Excel 2013? I didn't know this until just recently. ...