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 into a chart. How would you create this chart in...
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 display some metrics and am coming up with a blank...
How would you chart this in Excel for your executive dashboard?
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...
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 a few years ago and it would drive me crazy.
Here...
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. They want to modify a chart series in a graph...
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? Well then this tutorial is for you.
In previous posts I...
How-to Add Centered Labels Above an Excel Clustered Stacked Column Chart
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,...
Getting to Know Excel Text Fuctions and Functions
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...
Soap Story Dashboard
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...
How-to Make an United States Flag Excel Chart (Happy 4th of July)
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...