Stacked Bar With Distribution Within a Given Range

[udi]

Hello,

I am looking to create a stacked bar with distribution within a given range for seo keyword performance reporting. Here's what i have.

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.

Any help?

[Steve=True]

Hi Udi,

Sorry that you didn't get a response sooner. I have a few ideas on the subject that you requested and using your sample data. You can check out the tutorial and video here:

SEO Performance Charts

Let me know if this is helpful. Thanks.

Steve=True

[udi]

Hi Steve,

Thank you!

However, unless i am missing something, the examples you've provided do not the 1-10, 11-20, 21-30 results on a single plot (stacked). I need this becuase i am plotting month to month data.

Any suggestions?

thanks
Udi

[Steve=True]

Hi Udi,

I thought we captured that in one of the solutions. According to your question, it looked like this one would fit the bill:

Top102030.png

Is this picture close to what you want? This solution is scalable to multiple dates.

If not, how would you change it?

Steve=True

[udi]

hi.

yes, but i can't seem to get this for multiple months. When i recreate this, excel shows days between the months.. if i do 10 entries with 9/1/2013 and 10 entries with 10/1/2013, the graph will have 9/1, 9/2, 9/3 etc.. am i doing something wrong? here's what happens - https://www.evernote.com/shard/s5/sh...679a11c7517b2a

[Steve=True]

Hi Udi,

This should do the trick.

SEO Keyword Chart

Let me know your thoughts.

Steve=True