Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data.
Read it over, but really, the last line of the...
Advanced Excel Summation Techniques Using Pivot Table
There are many ways to Sum data in Excel. But when you have lots and lots of data, then you will want to learn...
Friday Challenge – Create a Percentage (%) and Value Label within 100% Stacked Chart?
First I want to say I am sorry to those waiting to see the dynamic chart scroll bar tutorial. My project launched this week...
Chart Increase at Time Interval in Excel
Here is my answer to the most recent Friday Challenge. Would welcome any comments below on what you think (flaws, likes, thoughts…)
In case you...
Friday Challenge Answers – Graph Increase at Time Interval
Hello everybody. We had a two answers submitted by our friends Don and Pete. Surprisingly, they had the same thought.
They both thought that the...
Challenge Answer – Negative AverageIf for Non-Continuous Range
In our last Friday challenge:
Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous Ranges
I wanted to see how you...
Friday Challenge – Create a Chart to Display a Music Festival Schedule
Here is an interesting question that I saw and I thought I would present it as the next in the series of Friday Challenges.
This...
Friday Challenge – Graph Increase at Time Interval
Hi All, I have been traveling and very, very sick this week. I am coughing almost every minute or so. Therefore, I was unable to...
Stacked bar chart with data from multiple columns – How would you do it?
Hello everyone! Thanks for being a fan. I am such a fan of Excel, that meeting MrExcel this week threw me off my schedule. ...
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...











