In the example shown Product A is getting a 10 percent increase. Apply the formula to other cells to get the result. Select the data range that you want to create a chart but exclude the percentage column and then click Insert Insert Column or Bar Chart 2-D Clustered Column Chart see screenshot.
The percentage increase between September and.
Percentage Change Formula The percentage between the two values is simply calculated by taking the difference between two numbers and dividing it with the original number. To format the result as a percentage click the Percent Style button in the Number section on the Home tab. Keep selecting the result cell then click the Percent Style button in the Number group under Home tab to format the cell as percentage. Select the chart go to the Format tab in the ribbon and select Series Invisible Bar from the drop-down on the left side.