I'm having trouble sturcturing my data to achieve what I need in a stacked bar chart. Basically, I need a chart with the months of the year for the category axis. For each month I have 2 item types (two bars) to be plotted as values on the Y axis. For for each item type there are multiple sub-types (the stacks for the bars). Example; For each month I have red and blue items that are sold in different regions. The red and blue items need to be stacked in a seperate bar with each showing their region values. The data for one month might look like this:
January
Red: 2 North, 1 South, 4 East, 1 West
Blue: 3 North, 2 South, 1 West
Can someone help me understand how to layout the data?
January
Red: 2 North, 1 South, 4 East, 1 West
Blue: 3 North, 2 South, 1 West
Can someone help me understand how to layout the data?