Area Chart
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 Excel Area Chart with blank data, Excel will interpolat
EXPLORE THE LIBRARY
Tag
Chart
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 your graphs. It is really simple, but some people do n
Chart
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 advise if it is possible to combine a pivot line graph a
How-To
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 fun than with some pranks. And better yet, Excel Pranks. I saw a great thread
Text
How to Fix Excel Wrap Text Feature when Your Rows Stop Expanding
In Excel, you will frequently have text that is longer than the cell width and you will often use the Wrap Text feature to make it more readable. However, have you ever had a row that stoppe
Challenge
Friday Challenge – Allocation Formulas
Facebook Twitter Pinterest WhatsApp Linkedin Today I have 2 formula challenges that you may find interesting. They are both different types of allocation formulas. Challenge 1: Problem: You
Bar Chart
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 labels as the default will appear in their own se
Bar Chart
Create a Excel Gantt Chart to Display a Music Festival Band Schedule
Facebook Twitter Pinterest WhatsApp Linkedin 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 r
Conditional Chart
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 schedule in the worksheet area using ce
Challenge
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. 1) Make a chart using Conditional Formatting and 2) Make