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 month”

I need to make a graph that charts data by person for multi-years by month. How can this be done and what type of graph is the best.
– Thanks, Dave

Download the sample data file and let me know how you would chart it in Excel.  If you want to send me your file, simply leave me a comment below (don’t worry, your email will only be shown to me) and I will shoot you an email as to where you can send the file.


Good luck and thanks for being a fan!