Stacked Column chart that groups dates by month

[StrawS]

Gidday,

I have the following list of data and am having trouble arranging it in a stacked column chart.
Column A = Completed date
Column B = Project name (just a letter)
Column C = Work units (the variable data).

--------------------------
Completed Project Work units
15/12/2010 A 30
20/12/2010 B 67
23/12/2010 C 92
14/02/2011 D 108
16/02/2011 E 50
18/02/2011 F 45
18/02/2011 G 29
4/04/2011 H 38
6/04/2011 I 8
6/05/2011 J 256
K 444
22/06/2011 L 242
M 21
N 16
O 29
P 146
Q 175
R 191
------------------------------

Chart specifications:
Y axis = "Work units" data.
X axis = time measured in months (one column per month).
Layers of each column = the various projects completed in that month.

Chart should not plot records with no "completed" date.
Chart should display months where no projects were completed.

Please let me know if the solution requires my data to be sorted in any particular way (I would ideally like a solution which doesn't require any sorting, but am open to anything).

So far I've been fluffing round with pivottables to try and arrange the data before charting... but I suck at pivottables so am getting nowhere. Not even sure if that's a necessary step.

Thanks for any help!

Straws

 

[StrawS]

Ok, well if you don't happen upon any other solutions then thanks for all your help in sticking with this thread! Much appreciated.

 

[GlennUK]

It's been a pleasure. Are you in New Zealand? If so, what time is it there???

 

[StrawS]

Yeah NZ is right... and we're at 9:00pm on Friday.

you must be just starting your friday in england

 

[GlennUK]

I was in North Island just a few years ago ... for a wedding in Masterton ... loved it there. I thought it would be late ... shouldn't you be having a beer or two instead of doing Excel?

You are correct about the day just starting here ... just had breakfast ... coming up to 10:00 am.

 

[StrawS]

Masterton, ah yes.

I'm in Christchurch myself.

Well I should be beer-ing, or something similar but I've unfortunately got a lot of non-work work to do if you know what I mean, and I saw your post come up which is much more interesting than what I'm doing... so it was a welcome distraction.

will knock off and go relax soon tho.

 

[GlennUK]

Ah Christchurch ... I'll bet there's a lot of rebuilding going on there. Have a good relax, and catch you soon.

 

[StrawS]

Yes, and spontaneous demolition with the continuing quakes.
10 months... and counting.