Tag: Excel
Soap Story Dashboard
I am traveling about 100% of the time for my current job. So I spend many more nights in a hotel room than my...
How-to Make an United States Flag Excel Chart (Happy 4th of July)
Happy July 4th (United States Independence Day).
I am home and not working too much this holiday, but wanted to send out a post on...
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...
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...
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...
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...
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...
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...
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...
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...
