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

3
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...

The Tricks to Writing a Conditional Formatting Rule Formula

0
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...

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...

Creating Excel Stacked Column Chart Label Leader Lines/Spines

0
In my last post, I showed you how to create a Brace/Curly Bracket/Mustache InfoGraphic type grouping in an Excel Stacked Column Chart. You can check...

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...

Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard

0
People are awesome and so creative.  We have been talking about building an Olympic Medal Count Dashboard using Excel and I asked for your...

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...

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 a Horizontal Tornado Chart Comparison

0
Recently in an Excel Forum, a user was asked to create a chart that compared 4 companies by month in a Column Chart. HOWEVER, there...

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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link