Excel Stacked Area Time Chart – Friday Challenge Answer
In our recent Friday Challenge, a user asked this:
"This is a scatter with smooth line and markers graph. What I would like to have...
3 Ways to Add a Target Line to an Excel Pivot Chart
Add a Target Line to an Excel Pivot Chart
Many Excel users use Pivot Tables and they find it very easy to create a Pivot...
How-to Create Modify and Delete an Excel Pivot Table Calculated Field
I am sure you have created a Pivot Table in your Excel Workbook. However, have you wanted to easily learn how to add a...
How-to Draw a Straight Line with Excel Shapes
Have you ever tried to draw a straight line in Excel only to get frustrated?
It can be so Frustrating :) to be off by...
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...
Excel Pranks: Non-VBA Edition 1
We should have some fun as it is the start of a long weekend and the end of summer.
So what better way to have...
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...
How-to Make a Music Festival Schedule Using Excel Conditional Formatting
Recently, I saw an Excel User posting a question about how to make this Music Festival Schedule using Excel Charts.
However, he originally created the...
