How-to Format Trend Line Color in Excel Dynamically

0
Many users use Trend Lines in Excel charts and graphs.  They may also be used in Company Dashboards, but to you can make your trend line stick out by making it change Format Dynamically. ...
treadmill dashboard design for excel

Dashboards are Everywhere!

0
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 jumped on the treadmill and low and behold, what do...

How-to Show Decades and Highlight a Year in the Horizontal Axis

4
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 Axis to show only every 10 years and also, how...
Link Chart Title to Cell

How-to Make an Excel Chart Title Change Dynamically

9
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 is possible? It is really easy to do, but some find...
Excel Chart with Yoda Quote

Yoda Excel Chart!! NO WAY!

2
Someone sent me this graph and I thought it was great.  I love Star Wars.  I grew up on Star Wars.  I lived and breathed Star Wars Trilogy as a child and I also...
Excel Legend Tips and Tricks

Tips and Tricks – Longer Legend Color Bars in Excel Charts

7
Here is a real quick tip that you may want to learn when using Excel.  This tutorial will help you apply this technique to your charts to make them more readable. Here is what a...
Practice Excel Helps Learning

Practice Makes Perfect Excel Dashboards and Charts

2
I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate graphs that you see in the press.  I have a...

How-to Make a Conditional Column Chart in Excel – REDO

2
· In a previous post, I showed you how to make a Conditional Column Chart for your Executive Dashboard Templates, but I had 3 steps to many in the tutorial.  This post has a...

How-to Make a Sales Pipeline Funnel Excel Chart Template

28
You probably have seen this type of Funnel Chart in Business Intelligence (BI) software packages and wondered how-to make this type of chart in Excel.  In this post, I will show you how to...

Weird Excel Charts

0
Have you ever seen a chart or graph like this in Excel? I created this chart using Excel the other day. It IS one combined chart using Excel. It is is NOT Two charts overlaid on top...