Formula help

[Scrumpywill]

Hello,

Could anyone please help, I have last years sales figures month by month and this years sales figures I would like a formula to compare sales percent increase or decreases per month and add a minus highlighting the percentage decrease

Many Thanks for your help and advice

Cheers

 

[r1998]

Hello Scrumpywill
Select the data from a1 to m21, then on top left , click on Insert, and then in charts section, click on the required chart type