Age distribution graphs are very powerful tools for visualizing the ages of different genders, ethnicities, and groups of different ages. It not only gives clarity in representing the ages but also makes it look appealing to the viewers. * Excel *has some amazing features to make a graph to represent age distribution. In this article, we will show how to create age distribution graph in

*.*

**Excel**## Download Practice Workbook

You can download the practice book here.

## 2 Easy Ways to Create Age Distribution Graph in Excel

In this article, we will show * 2* ways to create and represent age distribution graph in

*. Firstly, we will create a graph of age distribution that has no space between the two existing groups and the Y-axis is to the left. In the second method, we will create a graph that has its Y-axis value in the middle.*

**Excel**### 1. Graph Without Gap in Between

In this instance, we will have the Y-axis value to the left of the graph. To do that, first, we will sum all the people of all ages of a particular group using * the SUM function*. Then, we will calculate the percentage of each group contributing to the total. Finally, we will plot the graph. Follow the steps below to do so.

**Steps:**

- Firstly, select the
cell and write the following formula,**C11**

`=SUM(C5:C10)`

- Then, hit
.**Enter**

- Consequently, we will have the summation of males of different ages.
- Do the same for the
group.**Female**

- Then, select the
cell and type the following formula,**E5**

`=-(C5/$C$11)`

- Hit
.**Enter**

The formula has a minus sign in front of it. It is because we want to plot this data to the left of the chart.

- As a result, we will have the percentage of males belonging to that age group.
- Lower the cursor down to the last data cell to
**autofill**.

- After that, go to the
tab.**Home** - From there, select the
sign under the**%**option.**Number**

- As a result, the data will be presented in a percentage format.
- Meanwhile, click on the
cell and write the formula below,**F5**

`=D5/$D$11`

- Then, hit
.**Enter**

- As a result, we will have the proportion of females contributing to the total from that age group.
- Move the cursor down to autofill the rest of the cells.

- Convert the proportion of females into percentages in the same way as males.
- Afterward, select the
,**Age Group**, and**Male%**columns.**Female%** - After that, select the
tab.**Insert** - Then, choose the
option.**Insert Column or Bar Chart** - Finally, from the drop-down, select the
**Stacked Bar****C****hart**.

- Consequently, we will have our chart for our data.

- Firstly, select the labels on the graph.
- Secondly, choose the
tab.**Series Options** - Thirdly, choose
.**Labels** - Finally, from the drop-down of the
option select**Label Position**.**Low** - As a result, the data labels will be to the left.

- Select the
label.**X-axis** - Then, go to the
option.**Axis Options** - Click the
option.**Number** - Then, in the box under the Format Code option write the following,

`#,##0%;[Black]#,##0%`

- Finally, click
.**Add** - Consequently, all the negative values in the
will be gone.**X-axis**

- Now, click on the bars of the
group.**Female** - Then, select the plus sign to the right of the graph.
- Finally, check the
box.**Data Labels** - As a result, we will have labels on the data. Now, we need to reposition it.

- So, select the data labels.
- Go to the
tab.**Label Options** - Then, mark the oval beside
under the**Inside End**option.**Label Position** - As a result, the labels will be repositioned to the far right of the graph.

- Now, repeat the process for the
column**Male%***.* - The only difference is, in this case, check the
oval instead of the**Inside Base**oval.**Inside End**

- Finally, we can present our
graph.**Age Distribution**

**Read More: How to Create Age and Gender Chart in Excel (3 Examples)**

**Similar Readings**

**How to Calculate Retirement Age in Excel (4 Quick Methods)****How to Calculate Age from Birthday in Excel (8 Easy Methods)****Group Age Range in Excel with VLOOKUP (With Quick Steps)****How to Calculate Age in Excel in dd/mm/yyyy (2 Easy Ways)****How to Calculate Average Age in Excel (7 Easy Methods)**

### 2. Graph with Gap in Between

In the previous method, we positioned our * Y-axis* value on the left. In this method, we will set it in the center. Also, in this method too we will have to sum the number of people in a particular group and then calculate the proportion of people in each age group. Those steps will be the same as the previous method. So, here will start with inserting a graph. Another thing is, in this method, we will plot another column of data and the name of the column is Gap. This will allow us to have space between the two groups in the plot and insert the

*value in the center.*

**Y-axis****Steps:**

- Firstly, select the entire data.
- Secondly, choose the
tab.**Insert** - Thirdly, click on the
option.**Insert Column or Bar Chart** - Finally, from the available options, select the
chart.**Stacked Bar**

- Consequently, we will have a graph with a
data in between the main data.**Gap**

- Select the
data.**Gap** - Then, go to
.**Series Options** - From the drop-down of
select the**Fill,**command.**No Fill** - Finally, select
under the options of**No Line**.**Border**

- Then, select the plus sign on the right upon selecting the data in the gap.
- Check the
option.**Data Labels** - As a result, we will have
in each level which is the value of each cell in the**0.1**column.**Gap**

- To change that, go to the
tab.**Label Options** - Then, first, uncheck the
checkbox.**Value** - After that, check the
box.**Category Name** - Consequently, we will have the
value in the middle.**Y-axis**

- Now, select the data labels on the
data and delete them.**Male%**

- Then, select the
values.**X-axis** - Go to the
**Axis Options**. - Select the
option.**Number** - Finally, under the box of the Format Code option write the following,

`#,##0%;[Black]#,##0%`

- Click on the
command.**Add** - As a result, the
will have no negative value.**X-axis**

- Then, select the
axis label and delete it.**Gap**

- Then, follow the same steps as the previous method to add labels to the data.
- Finally, we will have our Age Distribution graph with
values in the middle.**Y-axis**

**Read More:** **How to Make Age Pyramid in Excel (2 Suitable Methods)**

## Conclusion

In this article, we have discussed * 2* easy ways to create an age distribution graph in

*. In these examples, we did not format the graph in simple ways. Readers could decorate the graph according to their tastes. However, the basic steps will be the same as this article.*

**Excel****Related Articles**

**How to Convert Date of Birth to Age in Excel (3 Easy Ways)****How to Calculate Age in Excel for Entire Column****Excel VBA: Calculate Age from Date of Birth****How to Calculate Age in Excel from ID Number (4 Quick Methods)****Calculate Age in Excel in Years and Months (5 Easy Ways)****How to Calculate Age on a Specific Date with Formula in Excel**