Practice Makes Perfect Excel Dashboards and Charts
I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate...
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? ...
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...
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 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...
Step-by-Step Horizontal Bar Chart with Vertical Lines Tutorial
In a recent request for help in the MrExcel Forums, a user was having difficulties adding Vertical Line KPI Metrics to a Horizontal Bar...
This is the Bomb: or How I came to love the Offset function
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...
How-to Make a Tenant Timeline Excel Dashboard Chart
So last week, I posted this question that I responded to in an Excel forum. I also asked you how you would solve this...
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...
Welcome to the New Microsoft Excel Dashboard Templates Blog where you will learn how...
This is my new blog dedicated to helping you learn and make your own Dynamic Microsoft Excel Executive Dashboard Templates and Charts.
I have many...
