Tenant Timeline – How would you create an Excel chart for this data?
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...
Presenting Metrics Data – How would you create a chart for this data?
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...
How-to Make Excel Put Years as the Chart Horizontal Axis Categories
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...
The Quickest Way to Select an Data Series in an Excel Chart
In a previous post, I showed you how to get around a frustration that many Excel users have when creating an Excel Dashboard chart. ...
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? ...
Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
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...
Creating Pick Lists in Excel for your Dynamic Dashboard
Creating Pick Lists in Excel
If you want to create a dynamic dashboard in Excel, I am sure you will want to use a picklist...
Steve Williams Caddie Earnings After Tiger Woods Split – Mini Dashboard
Now, you may know that I am a PGA Tour Golf fan and you may also know that Tiger Woods has been doing very...
How-to Easily Create a Stacked Clustered Column Chart in Excel
Create a Stacked Clustered Column Chart in Excel
There is one type of chart that is always requested, however, Excel doesn’t offer this type of...
