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.
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:
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
My solution has been submitted.
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.
An example of a bubble chart.
The idea is taken here https://sites.google.com/site/e90e50charts/
bubble chart in https://sites.google.com/site/e90e50charts/ looks great but it doesn’t show you the age range.