Make a Pie Chart Rating for Excel Dashboard Chart Templates
In a recent forum post, a dashboard user was asking how they can turn a decimal like 1.5 out of a 3.0 possible into...
How-to Format Trend Line Color in Excel Dynamically
Many users use Trend Lines in Excel charts and graphs. They may also be used in Company Dashboards, but to you can make your...
Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data.
Read it over, but really, the last line of the...
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...
Excel Dashboard of the Top 250 Movies – Don’s Friday Challenge Entry
Here is our next submission from the last Friday Challenge for the Internet Movie Database Top 250.
Below you can download an awesome Excel Dashboard...
How-to Create Dynamic Excel Dashboards Using Picklists
This is a great technique that you can use to create dynamic charts that will change when your users change the values from the...
Free Dashboard Template Download – BMI Weight Tracker
In this ever expanding universe, so is my belt. I need to drop more than a few pounds.
Now I can use an Excel Dashboard...
How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart
Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...
Think Like a Database Designer Before Creating an Excel Dashboard Chart
Recently, a fan asked for some help. However, when I got their file, I saw that they needed some help with basic concepts, so...
Company and Industry P/E (Price to Earnings) Line Chart – 2 Ways
Here is a fun and easy Dynamic Excel Chart that you can use in your Excel Dashboard Template.
This Excel Chart has many financial research,...