Friday Challenge – The Right Graph Style For What I Want to do
A newer Excel Chart creator had this question:
"This is a scatter with smooth line and markers graph. What I would like to have displayed,...
Friday Challenge – Step Chart for an Excel Time Series
I was recently asked for assistance with this request:
Hi Steve,
I am trying to make a hypnogram with data that we collected over the course...
Friday Challenge – Data Transformation
This weekend starts the ModelOff competition.
"ModelOff is the world’s largest professional competition for Microsoft Excel, Financial Analysis, Investment Analysis and Financial Modelling." -Modeloff Site
If...
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 – Showing More Categories in an Excel Chart
Can you help Kevin with his problem?
Kevin saw this article:
How-to Add a Line to an Excel Chart Data Table and Not to the Excel...
How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs
I didn't receive any sample formulas from Friday's post that included a Friday Challenge, so maybe I stumped everyone when asking you to create...
Friday Challenge – My Answer – Chart This Data in Excel
Challenge – Chart This Data in Excel - My Answer
A few Fridays ago, I posted this challenge:
Link here: friday-challenge-chart-this-data-in-excel
Where I asked you to send...
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...
Friday Challenge – Recreate this WSJ Chart
I thought I would give you all something to do before we finish the final posting on Excel Chart Sheets.
So I have been traveling...
Friday Challenge – Allocation Formulas
Today I have 2 formula challenges that you may find interesting. They are both different types of allocation formulas.
Challenge 1:
Problem: You have 9 tasks...
