Chart
How-to Highlight or Color Rings in an Excel Radar Chart
Step-by-Step Tutorial on making Excel Radar Chart Colored Rings
EXPLORE THE LIBRARY
Dashboard Design
Dashboard
How-to Quickly Mock-up Data for a Dashboard Template
How to make random test data using RandBetween Function for Company Dasboard using Excel
Dashboard
Titanic Mortality Dashboard
Dashboard made with Excel for a graphical representation of Titanic deaths, survivors broken down by ticket class, gender, crew and children.
Chart
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 to double the rate and double the billable ho
Dashboard Design
Excel VLOOKUP–Left or Right and HLOOKUP Up or Down
Understanding and learning the Left Vlookup functionality in Excel by using Index/Match Functions and Formulas
Banding Horizontal
Dashboards are Everywhere!
Look for dashboard designs in every day life to make your excel dashboards better and more useful.
Axis Formating
How-to Show Decades and Highlight a Year in the Horizontal Axis
This is the dashboard tutorial that will show you how to only show the horizontal axis categories that you want to show and how to highlight a specific value
Chart
How-to Make an Excel Chart Title Change Dynamically
Easy way tomake a dynamic chart title in Excel Chart and Graph
Bar Chart
Tips and Tricks – Longer Legend Color Bars in Excel Charts
Tips and tricks to change the excel chart legends to have longer color blocks
Banding Horizontal
Practice Makes Perfect Excel Dashboards and Charts
Practice making a NY Times Excel chart