Halloween Special – Spider Web, Spider and the Fly Chart

0
In honor of Halloween I thought I would post something fun.  For those that are not in the USA, Halloween is where children dress...

How-to Close the Gaps Between Chart Series in an Excel Stacked Clustered Column Chart

Many users like to create a chart that Excel doesn’t have as a chart type.  It is a combination of a clustered column and...

How-to Show Gaps in a Line Chart When Using the Excel NA() Function

4
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart.  In essence, he wanted to...
Download a Free Target BMI Weight Tracker Spreadsheet

Free Dashboard Template Download – BMI Weight Tracker

13
In this ever expanding universe, so is my belt.  I need to drop more than a few pounds. Now I can use an Excel Dashboard...

How-to Format Trend Line Color in Excel Dynamically

0
Many users use Trend Lines in Excel charts and graphs.  They may also be used in Company Dashboards, but to you can make your...

How-to Make a Company Goal Chart or IPAD Battery Chart in Excel

10
I was looking at my IPod Touch and I really liked the battery graphic that is shown.  Then I looked at my IPhone and...

How-to Make an Excel Vertical Likert Line Chart with Categories

26
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel.  The person...
Sample File of Excel Template Dashboard Tutorial Offset Function

This is the Bomb: or How I came to love the Offset function

7
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...

How-to Show Decades and Highlight a Year in the Horizontal Axis

4
Recently in an Excel Forum, a user had data similar to this format: Here is what he wanted to do:   How do I set the Horizontal...

Make a Pie Chart Rating for Excel Dashboard Chart Templates

0
In a recent forum post, a dashboard user was asking how they can turn a decimal like 1.5 out of a 3.0 possible into...