How-to Create and Copy a Table in Google Mail (Gmail) from Excel

30
On a recent project of mine, I tasked a team member with creating a communication to send out to users.  This communication involved making a table in the body of the email.  We use...

How-to Make a Non-Chart Excel Dashboard Chart (Heat Index)

0
So I saw this chart in an Excel forum and a user was asking this: “chart - not sure about this one I've created a few different types of charts in Excel over the years,...

How-to Create a Sick Leave Excel Dashboard Chart

0
Okay, I got an email from a SUPER FAN of my sight.  She even donated some money to help cover the costs of that we incur to bring you these Excel tutorials.  Kathy, thank...

How-to Make a WSJ Excel Pie Chart with Labels Both Inside and Outside

4
I thought it was a in last week’s USA Today, but looking at the picture I took more closely, it may have been produced by the Wall Street Journal.  Either way, when I saw...

How-to Add Label Leader Lines to an Excel Pie Chart

2
This a an awesome technique to make your pie charts stand out in your Excel dashboard.  However, I didn’t know about it for the longest time. It is called Label “Leader Lines”. Here is an example...

Removing Array Formulas Around Your Excel Charts and Dashboards

0
Yesterday I posted a quick tutorial on protecting your Excel Dashboard Charts by using Array Formulas. You can check out that posting here: Protecting Your Excel Charts and Dashboards with Array Formulas Well I guess I forgot...

Protecting Your Excel Charts and Dashboards with Array Formulas

2
Has this ever happened to you? You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared drive.  And then you get this call from your CEO...

How-to Create Dynamic Excel Dashboards Using Picklists

15
This is a great technique that you can use to create dynamic charts that will change when your users change the values from the picklist.  I detailed how you can create a pick list...

Creating Pick Lists in Excel for your Dynamic Dashboard

3
Creating Pick Lists in Excel If you want to create a dynamic dashboard in Excel, I am sure you will want to use a picklist to change your data set at one time or another. What...

Problems with an Excel Dashboard Goal Chart

4
A while ago, a user in an Excel help forum had a chart in his Excel Dashboard that was acting quite strange and he wasn’t sure what the problem was. Here is what he described:...