Stacked Bar chart showing top 10 Categories over time

[brf10043]

Guys,

I have a support group that wants a chart that shows the top 10 support categories in a bar chart by week.  In other words for each week there would be a bar with 10 segments with a count of the top 10 categories for that week.  On the on-site I thought this would be pretty straight forward, but as I get into it, I'm not sure how to produce a chart like that.

They are looking for some to replace this excel file.

Thoughts?

[MarcoWedel · Accepted solution]

Please share some sample data to work with.

[brf10043]

Thanks Marco. I managed to work out the chart.  However, I'm now struggling with a table.

I am trying to replicate this Excel table. In my chart the Date and Category is the dimension and the count is the expression.

Here is what I have so far in the table work.  Any Ideas how to format a table like the one above from Excel?

[MarcoWedel]

Glad it worked out for you.

Please close this thread and open a new one for your new question (so it matches the thread title).

thanks

regards

Marco