Charts - With Stacked columns representing similar data grouped

[adeeshc]

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.

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>

 

[ParamRay]

.
.

Arrange your data in the following way before creating your stacked column chart. (The cells in column A are merged.)

https://onedrive.live.com/redir?resid=E44F2D116D457095!248

 

[adeeshc]

.
.

Arrange your data in the following way before creating your stacked column chart. (The cells in column A are merged.)

https://onedrive.live.com/redir?resid=E44F2D116D457095%21248

Hi gpeacock,,

Thanks for the reply, but im unable to access this file. Would you be kind enough to upload the file differently or send to adeeshc@gmail.com

Thank You.