Tag: Excel
Excel Southern California Social – Meetup in Santa Monica Weds July 31 2013
I just saw this post from Mr. Excel. I am so excited to meet a hero of mine.
How cool is that I will be...
How-to Make a Tenant Timeline Excel Dashboard Chart
So last week, I posted this question that I responded to in an Excel forum. I also asked you how you would solve this...
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 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...
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? ...
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...
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...
