Surely, you can use similar approach,
The key point in the procedure described on peltiertech is adding extra empty data (As a matter of fact it was also used in my previous one). And for sure if you you shall not used aggregated data (as in Annual sheet in your DonationTimeline workbook).
See for instance attached - data is redistributed to have rows in every month for each charity (E17 and copy cown/right is an array formula).
As sometimes it happens that some charity is repeated, each occurence goes into separate column (I assumed that 4 will be enough here)
If you just draw stacked bar from such data you could have a good basis.
To keep an eye on grandtotal each month I added separate column. This grandtotal is drawn on primary axis and all other series on secondary. If grandtotal is not needed - would be a bit easier.
The horizontal axis is based on two columns to have nice location for month names on axis.
Then the coloring of four charities is made with simple VBA code - select a chart and run it:
Have a closer look from your distant location (I noticed changes in profile :-)))))) )
Of course, wa are again on the stage of no labels, but before preparing them would be nice to know if the graphical side is OK. Of course colours shall be taher changed - I used pretty basic, and nocesserilly nicely composed ones.
Bookmarks