Not sure how I can put the probelem.
Below is my data table. Need to create a chart from the data for each projects with months in the X axis and count in Y axis. Thing is that all 6 six projects should be represented for each month in 6 bars each, with each bar being stack split into external and internal count.
Tried checking similar threads but couldnt find a solution. Would be really grateful if someone could help with this.
<COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY>
</TBODY>
Below is my data table. Need to create a chart from the data for each projects with months in the X axis and count in Y axis. Thing is that all 6 six projects should be represented for each month in 6 bars each, with each bar being stack split into external and internal count.
Tried checking similar threads but couldnt find a solution. Would be really grateful if someone could help with this.
Project | January | February | March | April | May | June | July | August | September | |
A | Internal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
A | External | 9 | 10 | 10 | 10 | 9 | 9 | 9 | 5 | 0 |
B | Internal | 1 | 2 | 3 | 10 | 7 | 9 | 10 | 9 | 1 |
B | External | 24 | 25 | 26 | 35 | 31 | 28 | 25 | 20 | 0 |
C | Internal | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
C | External | 0 | 0 | 6 | 6 | 7 | 6 | 3 | 0 | 0 |
D | Internal | 31 | 33 | 44 | 43 | 42 | 28 | 24 | 13 | 0 |
D | External | 9 | 15 | 18 | 17 | 15 | 18 | 17 | 9 | 0 |
E | Internal | 0 | 0 | 1 | 2 | 2 | 1 | 1 | 1 | 0 |
E | External | 0 | 0 | 3 | 5 | 11 | 14 | 10 | 9 | 0 |
F | Internal | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 |
F | External | 0 | 0 | 1 | 2 | 3 | 2 | 1 | 1 | 0 |
<COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY>
</TBODY>