I have a table like below, the Price Change row which contains '300' for 2018 and '600' for 2019 is the sum of values of all products per year.
Price Change is a column defined by the formula P2-P1.
I want to transform the compare table above into a chart which is presented below.
Which type of calculations should I carry out, to make it happen. I couldn't really make use of the functions. I hope compare table experts can shed some light on it.