The line graph is one of the basic graphs of Excel. We can simply select data and choose the line chart to make a line graph. But adding percentages in the line graph is a little bit tricky task. In this article, I will discuss **2** methods to make a percentage line graph in Excel.

**Table of Contents**hide

**Download Practice Workbook**

Download the following practice workbook to exercise while you are reading this article.

**2 Ways to Make a Percentage Line Graph in Excel**

We will show two methods here. One is a simple line graph adding a percentage. Another one is the stacked line graph which contains **percentages** by default. So, letâ€™s see the section below.

**1. Making a Simple Percentage Line Graph**

In this method, we will use the basic line graph feature to make a percentage line graph in Excel.

We will utilize the following dataset for this purpose.

**ðŸ“Œ ****Steps:**

- First, select
**Range B5:C9**. - Then, go to the
**Insert**tab. - After that, choose the
**Line with Markers**option from the chart list.

- Now, look at the following graph.

Values are not showing in percentage, right? To make this possible-

- Select the
**Vertical Axis**and press the right button of the mouse. - Next, choose the
**Format Axis**option from the**Context Menu**.

We can see the **Format Axis** window on the left side.

- Now, go to the
**Axis Options**field and click on the**Number**drop-down. - From here, choose
**Percentage**as**Category**.

- Put
**0**on the**Decimal placesÂ**box.

Now again, look at the graph! We can see values are showing in the percentage form in the **Vertical Axis**.

**Read More: ****Percentage Formula in Excel (6 Examples)**

**2. Making a Stacked Line Graph with Percentages**

In this part, we will use the 100% stacked line graph feature. It is worth mentioning that we do not need to add percentages in this graph separately.

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

**ðŸ“Œ ****Steps:**

- First, select the whole dataset.
- Then choose the
**100% Stacked Line with Markers**option from the**Chart**list.

Look at the following graph. We can see the percentage value is shown in the vertical axis.

**Read More: ****How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)**

**How to Make a Percentage Bar Graph in Excel**

Now in this section, we will see more; we will 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:**

- First off, select
**Range B5:C8**. - Next, choose the
**Clustered Column**as the chart type as shown before.

The following graph will be generated.

- Now, click on the
**Vertical Axis**. Then press the right button of the mouse. - Choose the
**Format Axis**option from the**Context Menu**.

- We can see the
**Format Axis**window on the left side. - Set
**Percentage**as**Category**and**Decimal places**.

- Again, look at the graph.

The percentage value is shown in the **Vertical Axis**.

**Read More: ****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)**

**How to Show Percentage Change in an Excel Graph**

More to add, we will make a graph and show the change in percentage in Excel within the graph.

We will compare the profit months. And then show the percentage difference.

**ðŸ“Œ ****Steps:**

- Go to
**Cell D5**and put in the following formula.

**Â**

`=C6-C5`

- Press the
**Enter**button and drag the**Fill HandleÂ**icon.

- Now, we will calculate the percentage difference. Put the following formula on
**Cell E5**.

`=D5/C5`

- Again, press the
**Enter**button and pull the**Fill HandleÂ**icon.

- Now, select
**Range B4:C11**. Select the**Cluster Column**option from the**Chart**.

- Press the right button of the mouse keeping the mouse 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.

Look at the graph. We can see a borderline on each bar.

- Click on the border. Then, 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 here.

- Finally, we can see the percentage value shown in the graph.

**Read More: ****How to Calculate Growth Percentage with Formula in Excel**

**Conclusion**

In this article, weâ€™ve described **2** ways to make a percentage line graph in Excel. Weâ€™ve also shown a bar graph here. I hope this will satisfy your needs. However, if you have any questions, leave us a comment. You can also send your problem through email at **[email protected]**.

For more Excel-related articles, help with an Excel formula, or a piece of VBA code, visit our website **Exceldemy.com**.

## Related Articles

**Calculate Percentage in Excel Based on Cell Color (4 Methods)****How to Calculate Percentage of a Number in Excel (5 Easy Ways)****Calculate Total Percentage in Excel (5 Ways)****How to Calculate Average Percentage in Excel (3 Easy Methods)****Percentage Difference Between Two Percentages in Excel****How to Use Excel Formula to Calculate Percentage of Grand Total****Calculate Gross Profit Margin Percentage with Formula in Excel**