crosstab chart shows totals instead of series

[shakespeare5677]

Hi folks,

I've got a chart that I based on a crosstab. The crosstab displays:

Week1 Week2 Week3 Week4
SeriesName1 1 0 0 3
SeriesName2 2 1 0 0
SeriesName3 3 2 1 0
Total 6 3 1 3

I know how stupid this sounds, but here's the problem - my chart, though properly set to display the values (which in themselves are sums of readtime formulas) on change of Week# and subdivided by SeriesName displays the week totals instead of its subdivided values.

I've done this millions (well maybe not millions) of times before, but apparently this time something is different and I have not idea what. I've check everything I can think of and nothing is different.

Please help. Thanks in advance.

-Max

 

[shakespeare5677]

Sorry, I'm using CR10. Thanks.
-Max