How to Make a Percentage Line Graph in Excel (2 Suitable Ways)

Method 1 – Making a Simple Percentage Line Graph

We will utilize the following dataset.

Steps:

• Select B5:C9.
• Go to the Insert tab.
• Choose the Line with Markers option from the chart list.

• Here’s the default graph. The values are not shown as percentages.

• Select the Vertical Axis and right-click on it.
• Choose the Format Axis option from the Context Menu.

• You’ll get the Format Axis window on the side.
• Go to the Axis Options field and click on the Number drop-down.
• Choose Percentage as Category.

• Put 0 on the Decimal places box.

• We can see values are showing in the percentage form in the Vertical Axis.

Read More: How to Make a Single Line Graph in Excel

Method 2 – Making a Stacked Line Graph with Percentages

We will consider the following dataset, which expresses the monthly cost.

Steps:

• Select the whole dataset.
• Choose the 100% Stacked Line with Markers option from the Chart list.

• The percentage value is shown in the vertical axis.

How to Make a Percentage Bar Graph in Excel

Let’s consider the ratio of different types of costs and present them in percentages with a bar graph in Excel.

Steps:

• Select B5:C8.
• Choose the Clustered Column as the chart type.

• The following graph will be generated.

• Right-click on the vertical axis.
• Choose the Format Axis option from the Context Menu.

• You’ll get the Format Axis window on the left side.
• Set Percentage for Category and insert the desired number of Decimal places.

• Here’s the updated graph.

How to Show the Percentage Change in an Excel Graph

We will compare the profit between months, then show the percentage difference.

Steps:

• Go to cell D5 and insert the following formula.

• Press the Enter button and drag down the Fill Handle icon.

• Put the following formula in cell E5.

• Press the Enter button and pull the Fill Handle icon down.

• Select B4:C11.
• Select the Cluster Column option from Chart.

• Right-click on the vertical axis.
• Choose More Options from the Error Bars drop-down.

• Check the options shown in the marked section. Choose Specify Value from the Custom section.

• Select the difference range from the dataset.

• Here’s the updated graph with border lines.

• Click on the border and click on the plus button.
• Select the More Options from the Data Labels drop-down.

• Mark the Value From Cells option.

• Choose the Percentage range.

• We can see the percentage value shown in the graph.

Download the Practice Workbook

Related Articles

• How to Make a Line Graph in Excel with Two Sets of Data
• How to Make Line Graph in Excel with 2 Variables
• How to Make Line Graph with 3 Variables in Excel

<< Go Back To Line Graph in Excel | Excel Charts | Learn Excel