Excel Magic Trick # 267: Percentage Change Formula & Chart

Learn about the universal formula for Percentage Change: (End Value)/Beg Value) 1 = Percentage Change. The see how to create and format a chart with two data series and two chart types in one chart: Line Chart and Column Chart.

Category:

Science & Technology

Tags:

• Excel
• Percentage
• Change
• Formula
• Column
• Line
• Chart
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[pliskiniroquis]

what is that -1 for? Was it referring to the "current month"-1?

[ExcelIsFun]

@pliskiniroquis , mathematically (End-beg)/beg is the same as End/Beg - 1.

[teohais]

Thanks dude definitely hit that like button

[ExcelIsFun]

@teohais , glad that you like it!!

[tillchelsea]

thx alot bro

[ExcelIsFun]

@tillchelsea , you are welcome!

[moazzamca1]

Infact every excel lover has a lot of fun with excel

[dingspicks]

Every now and then I stumble on a formula that I forgot about or should have been using. The percent of change formula you used in this video is one I had forgotten about, but will start using againg. Thanks!! I typically use the =(NewAmount-OldAmount)/OldAmou­nt to get my percent of total, but your formula is much more efficient. Appreesh my friend!!

[awiennn]

You saved my life. Bless you!

[ExcelIsFun]

I am glad that you liked it!

[ezezez3]

THANK YOU. This video was the perfect solution to my excel chart issue. Thumbs Up and Subbed.