Cannot create a stacked bar chart

[carmine1]

I don't often use charts in CR, but have successfully done so in the past without major problems. This one just will not work for me and I do not understand why. Can someone walk me through it? Using CR 2013/SP6.

I am trying to do the same within Crystal Reports, but failing miserably. The database is SQL and the data is being gathered by a SQL Command which summarizes the data exactly as shown above - lines 2, 3 ,4, 5, and 6 each represent a single record in the Command's result set.

[DellSC]

Please explain how the chart is failing - what's not working right?

[carmine1]

Well, for the longest time, I could not get it to display anything even remotely resembing stacked bars.

Suddenly, I have an actual stacked bar chart, but it is transposed from what I want - The weeks are stacked on top of each other and the Categories are along the X-axis.