Case Study: Executive Dashboard Chart Creation – Follow-up
The Problem
In a recent post:
“Case Study: Executive Dashboard Chart Creation” (https://www.exceldashboardtemplates.com/?p=1612)
I presented some basic data that you may have in your company that you...
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...
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...
Dashboards are Everywhere!
Dashboards Can Be Found Everywhere
I am presently in Suzhou China working on a new project and I decided to go to the gymnasium. I...
How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
How-to Make an Excel Chart Title Change Dynamically
Have you ever wanted to change your chart title dynamically?
Perhaps you wanted to link it to a cell value?
Did you know that it...
Tips and Tricks – Longer Legend Color Bars in Excel Charts
Here is a real quick tip that you may want to learn when using Excel. This tutorial will help you apply this technique to...