Hi,

I'm trying to graph the distribution of views of some articles on my website. I'm a little stuck on how to effectively bring all the data together in Excel and was hoping to get some wisdom from you guys! :-)

What I'm looking to analyse is how long these articles take to reach maturity from their date of publication (so, when they achieve their optimum performance).

I'd then like to further analyse this across various metrics like article type/producer etc., which, I guess, would be in some kind of Pivot Table filter-type-thing.

Here's an example of some of my data:

ArticleName - PublishedDate - OctViews - NovViews - DecViews - ArticleType - Producer
Article1 - Oct-08 - 3701 - 4856 - 4561 - Food - ABCTV
Article2 - Nov-08 - 0 - 9824 - 1256 - Food - ABCTV
Article3 - Oct-08 - 1358 - 8953 - 9652 - Tech - XYZ.com
Article4 - Oct-08 - 1351 - 2354 - 3562 - Tech - ABCTV

The part I'm finding tricky is this; what we'd like to do is rather than look at a specific date (say, articles published on 09/04/08) it would be useful to combine all the dates so that the first month something is published is Month 1, regardless of the date it is actually published.

As the same article can be from the same producer but published at different times, if I could remove the "Jan-Mar = Month 1-Month 3" problem it would allow us to graph all the data into one snapshot of the publishing process and find trends. If this could then be cross examinable by the ArticleType etc. it'd be really useful.

If anyone can help it'd be much appreciated! I think the above makes sense, but let me know if anything else is needed to decipher my gibberish.

Cheers!