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
/category/how-to/page/14/
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
Axis Formating
How-to Make a Horizontal Tornado Chart Comparison
Video Tutorial with Step-by-Step Instructions on how to make Horizontal Tornado Charts in Excel 2003 2007 and 2010 for your Executive Company Dashboard Template
Dashboard
How-to Format Trend Line Color in Excel Dynamically
Use a dynamic trend line to highlight dashboard trends in Excel templates with the use of color.
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
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
Chart
How-to Make a Sales Pipeline Funnel Excel Chart Template
Video Demonstration and Tutorial to make a sales Funnel chart or sales pipeline chart in excel for your executive dashboard template
Cell References
How-to Show All Formulas in Excel Spreadsheet
How-to see your formulas in an Excel spreadsheet by pressing Ctrl+~
Chart
How-to Make a Conditional Column Chart in Excel
A quick way to make a conditional column chart showing red and green bars in an excel spreadsheet
Cell References
How-to Show All Named Ranges/Formulas in a List
this will show you how to use the F3 key to paste a list of all the named ranges and defined names including formulas in Excel Spreadsheet