How-to Highlight or Color Rings in an Excel Radar Chart
Recently a user in an Excel Forum wanted to know if there was any way to highlight or color the outside ring of an...
How-to Quickly Mock-up Data for a Dashboard Template
I frequently need to create and test a chart design concept for Excel Dashboards. Therefore, I need chart data that is representative of the actual data,...
Titanic Mortality Dashboard
Today marks the 100th anniversary of the tragic sinking of the RMS Titanic. On that fateful day, over 1,500 people died when the Titanic...
Add % Difference Data Labels to Excel Horizontal Tornado Chart
Okay, the client is always requesting changes. How do you deal with these? I suggest increasing the contracted hours. In this case, I decided...
How-to Make a Company Goal Chart or IPAD Battery Chart in Excel
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
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...
Excel VLOOKUP–Left or Right and HLOOKUP Up or Down
Better late than never to the VLOOKUP week as started by Mr. Excel, Bill Jelen.
I have never been a big fan of the Excel...
VLookup Week at ExcelDashboardTemplates.com
The Awesome Mr. Excel has started a VLOOKUP week. Much like Shark Week, all the Excel sites around the web are posting VLOOKUP learning...
A Taxing Situation…
In order to prevent vehicle population from growing too fast and also to ease traffic, Shanghai China has begun to auction off license plates. ...
Zombie Pie Chart in Excel – What would you do?
The Walking Dead has been an amazing hit as a new show and is now finishing up its second season. Unfortunately, I am out...
