Excel Dashboard Templates

A user wanted to know how to create an Excel chart that shows when his tenant’s leases are expiring.  He wanted to put this into a chart.  How would you create this chart in...

In my last post I asked how you would create a chart for this request: Presenting Metrics Data Trying to find the best way to display some metrics and am coming up with a blank...

An Excel forum user posted the following question.  I wanted to see how my readers would answer the following question.  Tomorrow I will post my solution (although I am sure it is not the...

I saw this post in a forum yesterday and thought that everyone should know this.  Lord knows that I didn’t know this until just a few years ago and it would drive me crazy. Here...

In a previous post, I showed you how to get around a frustration that many Excel users have when creating an Excel Dashboard chart.  They want to modify a chart series in a graph...

Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list?  Well then this tutorial is for you. In previous posts I...

  I am currently working on a project in L.A. and a business analyst at the client site was looking for a chart to present his data to the CEO.  After looking at his data,...

Frequently I have to take other data sets and make sense of them.  Sometimes there is very little sense of the data, but every once in a while, you may find that the information...

I am traveling about 100% of the time for my current job.  So I spend many more nights in a hotel room than my own house.  So it reminded me of this funny funny...

Happy July 4th (United States Independence Day). I am home and not working too much this holiday, but wanted to send out a post on how to make a flag in Excel using Combination Chart. Here...