Peter reminded me of a really cool option that you have in Excel.
You may have never known about it. But it is fun and there is a use for it.
Are you excited to learn what it is?
Check out t...
Oct 08, 2013 No Comments
So I saw this chart in an Excel forum and a user was asking this:
“chart – not sure about this one
I’ve created a few different types of charts in Excel over the years, but I’m t...
Jun 25, 2013 No Comments
If you want to create a dynamic dashboard in Excel, I am sure you will want to use a picklist to change your data set at one time or another.
What do I mean?
Well, what if you had the following data a...
May 28, 2013 No Comments
Below is a video that may help you as well.
How-to make a Dynamic Excel chart that doesn’t show blank values so you don’t have to use filters.
It uses a combination of Index and Match fun...
Apr 15, 2013 No Comments
So all the US news agencies keep talking about the Fiscal Cliff. This reminded me of a problem that many people have when making an Area Chart. Given this data:
I have seen several posts where peo...
Dec 27, 2012 No Comments
In honor of Halloween I thought I would post something fun. For those that are not in the USA, Halloween is where children dress up in costumes and go door to door to beg for candy. Halloween al...
Oct 31, 2012 No Comments
People are awesome and so creative. We have been talking about building an Olympic Medal Count Dashboard using Excel and I asked for your designs. A reader of mine: Mitch designed and developed an...
Aug 14, 2012 No Comments
Excel formulas are a wonderful thing, but they may not provide all the flexibility you want when calculating information for your Executive Dashboard display. Sometimes you need to make your own for...
Feb 01, 2012 No Comments