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...
How-to Make a Company Goal Chart or IPAD Battery Chart in Excel
I was looking at my IPod Touch and I really liked the battery graphic that is shown. Then I looked at my IPhone and...
How-to Make an Excel Vertical Likert Line Chart with Categories
In the Mr. Excel forums there was a question raised on how can you create a Likert Chart or Graph using Excel. The person...
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my...
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
People are awesome and so creative. We have been talking about building an Olympic Medal Count Dashboard using Excel and I asked for your...
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...
Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second...
A fan of the blog asked a question about this post:
Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...
How-to Make Dynamic Excel Dashboard Charts Using Tables
For almost every Excel Dashboard you will want to make a Chart template Dynamic. Meaning that as you add new data, the chart updates...
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...
