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...
Add Multiple Percentages Above Column Chart or Stacked Column Chart
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart. You can see the...
How-to Make an Excel Bullet Chart
Executives and managers love to see gauge charts in their Excel Dashboards. However, gauge charts may confuse or mislead the dashboard readers. For instance,...
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...
Don’s Take on the Better Sales Funnel Chart
I got a positive comment from Don and he liked the Better Excel Sales Pipeline / Sales Funnel Chart.
But....he thought it lacked ***flash***!
So he...
How-to Easily Add Task Information to Excel 2016 Gantt Charts
Easily Add Task Information to Excel 2016 Gantt Charts
Excel 2013 and Excel 2016 make this need so much easier. Thanks Excel! I recently posted...
How-to Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
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. ...