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...
Make a Random Data Set in Excel

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...
Left Vlookup Formula

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...

treadmill dashboard design for 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...

Link Chart Title to Cell

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...
Excel Legend Tips and Tricks

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...

Practice Excel Helps Learning

Practice Makes Perfect Excel Dashboards and Charts

I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate...
Want to Receive the Next Post?
Join My Newsletter
Give it a try, you can unsubscribe anytime.
Privacy Policy
Subscribe Now!   (Privacy Policy)

Stay Connected!

Get the latest post emailed straight to your inbox!