Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous...
In a recent Friday Challenge, you were tasked with creating a formula that would work out for a non-contiguous (not connected) range that ignored...
Friday Challenge Answers – Cumulative Events Over Time
In our recent Friday Challenge,
Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time
where a user wanted the following:
Creating a graph of...
Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time
Here is a Friday Challenge that a lot of Excel users may run into.
Essentially, you are given a date and incident type that occurred...
Friday Challenge – AverageIf NOT Blank or NOT Zero – NOT So Easy
As an Excel dashboard engineer you will often need to create complex calculations for your charts, tables and displays. So today's challenge is one...
Friday Challenge – Mimic Newspaper Chart Line Style in Excel
Hi All,
Here is a fun challenge that I thought you might like. I saw this chart in the Denver Post and I wondered how...
Terrible Chart Follow-up
Hi All,
Sorry my postings have been a little slow. I had several things come up. 1) I got hacked again and had to spend...
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my...
Friday Challenge – The Boss Says “Can you create some graphs?”
Here is the scenario that thrills Excel data analysts and sends chills down most employee’s spines:
Thursday afternoon: Your department sent out an Excel spreadsheet...
Friday Challenge – How Would You Chart It?
Today the ExcelDashboardTemplate.com Friday Challenge is up to you and your wildest imagination.
An Excel chart newbie posted this data set and wasn’t sure the...
Friday Challenge – Recreate Pete’s Bullet Chart
Our good friend Pete sent me his take on the Recent Bullet Chart posting. I was dumb founded on how he created it. In...
