I hope you'll suffer a question from a novice :)
I'm trying to find the best way to graph (in Excel) the month-by-month share of site-wide visits and pageviews in five referral sources, grouping the remaining share as one: "other sources."
My thought was to do a clustered, stacked column chart, where each month has a cluster of two columns—visits and pageviews. Each column in a cluster would be stacked by source. The visits column would use one y-axis, and pageviews would use a secondary y-axis—pageviews have much higher values than visits. Please forgive me if any of this terminology is wrong.
Am I on the right track or is there a better way to visualize this data? If this is the way to go, any direction on how to arrange my data to coax Excel into getting all these parameters into one chart? Or does that question belong on a different StackExchange site?