How to Calculate Percentage Change. Calculating percentage change is one of the most frequently used tasks in Excel. The basic formula is: (New Value / Old Value) – 1.

How to Represent a Percentage of Time in a 24-Hour Cycle in Excel Graphs. Excel displays percentages of a whole using pie charts, also known as wedge charts of circle graphs.