I go nuts at Excel. So here's my problem: I have a table where the Y-values are projects that we are working on in that year on the x-values are project related properties. On of those properties is the month in which the project started.
So if you look into that column you'll find Jan, Feb, ... of which a single value might occur several times, because many projects might start in June and other in October. Now I could use a pivot table to see how many project started for instance in June.
But what I want is a stacked bar chart showing the names of those projects that started in Jan, Feb, Mar, ... And if possible the cash-value (another column of the table) used for the stack.
Here's a sample table. PS: I'm using Microsoft Excel 2011 for MacOS.
Project, Volume, Start
ProA, 80.000 Eur, Jan
ProB, 25.000 Eur, Jan
ProC, 12.000 Eur, Mar
ProD, 50.000 Eur, Sep
ProE, 35.000 Eur, Sep
The diagram should look like this: