Friday Challenge – Excel Mutli-year Graph by Month
For this Friday's challenge, lets see how we can help this user visualize this data set. Here was the Excel user's question:
"Mutli-year graph by...
Friday Excel Challenge Submissions–Which Chart Solution One Do You Like Best?
Sorry for the late posting. I was in Atlanta all week working on a new project and going out with the client at night,...
Thanks for the Friday Chart Challenge Submissions – Vote in the Poll!
I had some AMAZING submissions for the last Friday Excel Chart Challenge.
Check out the post and file downloads here: Friday-excel-challenge-submissionswhich-chart-solution-one-do-you-like-best/
And don’t forget to vote...
Data Transformation – Excel Array Solution
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages. Well although...
Petes Stumped Chart Challenge Answer – Pivot Chart with Slicers
In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set. They...
Analyzing Attendance Records with Charts and Trend Line with Sparklines
A big shout out to Don who sent in this solution to last week’s Friday Challenge: Analyzing Attendance Records with Charts and Trend Line. ...
SEO Performance Charts – Don’s Solutions
Sorry it has been a few days since my last post, but I have a lot that has been going on with new projects...
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...
Create a Excel Gantt Chart to Display a Music Festival Band Schedule
Here is Pete's answer to the recent Music Festival Schedule Challenge.
In this video, see how he used Index/Match functions as well as a helper...
Match Product Chart Colors to Excel Spreadsheet Cells – Pete’s VBA Solution
In the recent Friday Challenge: Create Pipeline Usage Chart
A user wanted to create a bar chart where the values had a specific color by...