How-to Make an Excel Chart Title Change Dynamically
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...
Using the Camera Tool to Create a Vertical Line Chart in Excel
Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...
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...
Dashboard Design Examples – Excel Chart X-Axis Grouping
When Designing an Excel Company Dashboard you will want to make sure that your audience can easily read and interpret the data.
Which do you...
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
Okay, we have learned lots of different techniques to build our Company Executive Dashboard using Excel, and today I will give you a taste...
How-to Make a Dynamic Chart Using Offset Formula
In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables. This is a very easy...
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...
Find the Last Row or Last Column for Dynamic Excel Dashboards
In a previous post “This is the Bomb: or How I came to love the Offset function” I showed you all about the Offset...
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...
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...
