Please see attached example
I have some source data (yellow section) which contains some values each month. These values can fall into 3 different categories A, B or C.
The pink section then uses a SUMIF to find the totals for each category.
The green section then finds the cumulative total for each category. This is the source data for the chart.
Is there any way I can get the same chart straight from the source data (yellow section)?
The attached sheet is just sample data the actual sheet contains many more line items and categories and it is a tedious task to do each month.