Excel Super Bowl Statistics Dashboard
A great big shout out to Don who submitted the best Excel Dashboard of Super Bowl Statistics.
It has a neat design and uses picture...
How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard
Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...
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...
How-to Create a Dynamic Excel Pivot Table Dashboard Chart
In my last 2 posts:
I showed you how to setup your data in preparation for creating a dynamic dashboard chart
Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
And then I...
How-to Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
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,...
How-to Eliminate Statistical Outliers in an Excel Line Chart
Okay, I posted this Excel Chart Challenge on Friday. How did you do? I am sure your solution is better than mine. This was...
How-to Add Custom Labels that Dynamically Change in Excel Charts
Have you ever wanted to have a different data point label in your Excel Chart than what is offered by the Standard Excel Dialog...
How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4...
This is an awesome guest post from our great friend Pete. He came up with this awesome technique to make a dynamic pie chart...
How-to Format Chart Axis for Thousands or Millions
Here is a great way to make your Dashboard Charts in Excel more appealing and your boss will love you and your friends will...