Friday Challenge – Stumped on How to Display Data in an Excel Chart

I had some great responses to the last Friday Challenge, so I didn’t want to stop the momentum with my answer to the last challenge, so I will post that next week.  So here is another challenge to cut your teeth.

Learn Excel Dashboard Course

This is a great challenge for any budding Excel Analyst and Excel Dashboard Creator.  You may very well run across a set of data like this and need to create a chart for your company.

This Excel user was confused on what chart to create from this data set:

Stumped Chart Data Set

Lots of users may have this same sort of problem.  The main issue that faces users with this type of data set is that the data looks like it may need a 3rd axis and it can throw some for a loop.





So what type of chart would you create from this data set?

Can you make I dynamic?

Download the data and leave me a comment on what type of chart you would make.

Also, if you would like to share your solution with others, send me a contact request at the bottom of the form and I will send you an email to submit your reply.

Stumped Chart Challenge Data.xlsx



Good Luck!

Steve=True





5 COMMENTS

  1. A 3D Clustered column chart seems to do the trick decently and updates dynamically as you update the information in the chart. You just need to make it decently large to see everything well.

LEAVE A REPLY

Please enter your comment!
Please enter your name here