How-to Create and Copy a Table in Google Mail (Gmail) from Excel
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)
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
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
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
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
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
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
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
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
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:...