Friday Challenge – Stacked Bar With Distribution Within a Given Range

Hello everyone.  Sorry, that I haven’t presented the solution to last Friday’s challenge yet, but I have been a bit under the weather and traveling, so I have been unable to get to it.  I had two great submissions from Don and Pete and they matched pretty closely to my solution.  However, mine has a few cool features that I wanted to share.  I will try and post my solution shortly.

In the meantime, I wanted to tide you over with something to think about.  In today’s Friday challenge, I present to you with this user conundrum.  Although it appears to be easy upon reading, it may throw some of my readers for a loop when the sit down and try and recreate it.


Stacked Bar With Distribution Within a Given Range

“I am looking to create a stacked bar with distribution within a given range for seo keyword performance reporting.

Say there are 10 keywords we are tracking.
5 are within the top 10 results
3 are within the top 20 results
2 are within the top 30 results

This would be one month – one plot on x axis.

The y axis should scale 0-30 at 10 point intervals, so 0, 10, 20, 30.”

– Excel User


Here is your mission, should you choose to accept it:

1) Recreate this chart using a stacked bar chart:image(Note: I didn’t follow their requirements 100% but I think my chart / infographic gets the message across that the user was trying to convey.)

2) Take it a step further and send me a better chart than my solution.

If you want to send me a submission, simple leave me a comment and one of the fields is your email address.  I will then send you my email so that you can send me your submission.

I will post the submissions received and also how I made this chart in Microsoft Excel next week.  Good luck!