Trying to make an area chart with components of a sum displayed as different colors

[Rickard_Abraham]

Gotta transpose your data! Here’s a relevant read

New formulas for columns

Originally coming from Excel I know the temptation of putting variables in columns, but I cannot remember now any case where improving the data model didn’t solve my need for getting the column with a formula. Why don’t you just use a data-model like in this example with a data point per row ? With grouping you can simulate the original layout if that’s more convenient for visualization or data input.