Hi Everyone -
I have a question regarding pivot charts about something that seems relatively easy...

I have weekly data for different categories of website referrers - things like Organic Search, Paid Search, Direct, etc. for each week.

I'd like to use a single stacked bar for each week and then show possible changes in those proportions over time (that is, across the weeks of my data).

For some reason I can select the stacked chart but it won't actually change the chart's appearance - it still shows a bar for each of the 6 categories for each week of my data. I also tried calculating a percentage to use that in place of the raw numbers but it won't let me do that either, perhaps because I filtered out one "blank" category so it's telling me that calculating a percentage would be invalid if I attempted that (?).

Anyway, I really just want ONE nice stacked bar for each week to be more understandable. Thanks for any help!