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.

Compare Table on Price Changes over Year per Product


I want to transform the compare table above into a chart which is presented below.

Price Change Chart


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.

Calculation and Formulas

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.