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...
3 Ways to Add a Target Line to an Excel Pivot Chart
Add a Target Line to an Excel Pivot Chart
Many Excel users use Pivot Tables and they find it very easy to create a Pivot...
Friday Challenge – How Would You Chart It?
Today the ExcelDashboardTemplate.com Friday Challenge is up to you and your wildest imagination.
An Excel chart newbie posted this data set and wasn’t sure the...
How-to Make and Add Custom Markers in Excel Dashboard Charts
When is a picture worth a thousand words? Definitely when you use custom markers in your Excel Charts.
This will make your Excel Dashboard Charts...
Titanic Mortality Dashboard
Today marks the 100th anniversary of the tragic sinking of the RMS Titanic. On that fateful day, over 1,500 people died when the Titanic...
Case Study Solution – Mom Needing Help on Science Fair Graphs/Charts
Yesterday I presented a case study on assisting a mom in creating a chart for a science fair.
You can read more about it here:
Case...
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...
Budget Analysts – How would you answer this Excel Chart question?
Two months back there was a posting in the Mr. Excel forums that I thought most budget analysts might be asked by there executive...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
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...
