FlowsBook a callSign inCreate free accountSign up
Population and demographics

How to draw the age pyramid of a neighbourhood from nine age groups

Draw the age pyramid of a neighbourhood from residents in nine ten-year bands, read its shape in a minute, and know the one thing this kind of pyramid cannot show.

Part of the guide Location intelligence automation

By the xMap team · · 5 min read

An age pyramid of a neighbourhood is a stack of bars, one per age band, youngest at the bottom and oldest at the top, each bar as long as the number of residents in that band. With residents counted in nine ten-year bands, from 0 to 9 up to 80 and over, you can draw one for any area you can mark on a map, and its shape tells you at a glance whether the place is young and growing, settled and middle-aged, or ageing.

Planners, clinic and school operators, retailers and property teams use the shape to decide what an area needs. This piece covers how to build the pyramid from the counts, how to read the four shapes you will meet most, a worked example with invented figures, what to watch out for, and a flow that draws a pyramid for every area on your list.

From nine counts to a picture

The Demographics block returns, for any point with a radius or any area you draw, the residents in each of nine bands: age_0_9, age_10_19, age_20_29 and so on up to age_80_plus. They come from xMap's population grid, small hexagons of about 0.1 square kilometres added up over your area.

  1. Mark the neighbourhood: draw its boundary in the Area of interest, or give a point and a radius.
  2. Get the nine counts with Demographics, totals for that area.
  3. Turn each count into a share of the whole, so different-sized areas can be compared: divide each band by the population.
  4. Draw one horizontal bar per band, 0 to 9 at the bottom, 80 and over at the top.

That last step can be a chart in a spreadsheet, or the Data analyst block, which works out the table of bands and shares and draws a bar chart of it in the run.

Reading the shape

  • A wide base that narrows quickly. Many children and young adults, fewer older people. Often a newer suburb full of young families. Schools, nurseries, play centres and family shops fit.
  • A bulge in the middle. Most residents aged 20 to 49, fewer children. Typical of a city centre with flats, students and young workers. Gyms, cafes and quick meals fit.
  • A column. Bands of roughly equal size. A settled, mixed area with no strong lean.
  • Wider at the top than the bottom. More residents over 60 than under 20. An ageing area, where pharmacies, clinics, home care and accessible transport matter more.

Look at the base and the top first, then the middle. The bars that stand out from their neighbours are usually the story.

A worked example with invented figures

These numbers are made up. A community health trust in Lyon is comparing two neighbourhoods for a new clinic and draws a pyramid for each from residents within 1 km.

Age bandNeighbourhood A shareNeighbourhood B share
80 and over2%7%
70 to 794%11%
60 to 697%14%
50 to 5910%14%
40 to 4913%13%
30 to 3919%12%
20 to 2924%10%
10 to 1911%10%
0 to 910%9%

Invented shares to explain the reading; not data about Lyon. Read from the bottom row up, as the pyramid is drawn.

Drawn as bars, A bulges strongly at 20 to 39 and thins fast above 50: a young, working-age district. B is close to a column up to 50 and then stays wide, with nearly a third of residents aged 60 or more. For a clinic aimed at long-term conditions, B is the stronger case. For a sports injury clinic, A.

Mistakes to avoid

  • Comparing counts, not shares. A big area has longer bars in every band. Convert to shares before you compare two areas.
  • Drawing over too large an area. A whole city averages out the neighbourhoods inside it. Keep the area to the size of the decision, a district or a 1 km circle.
  • Reading a pyramid as a forecast. It shows who lives there now. It does not say who will move in.
  • Over-reading small bars. The top bands are small in most places; a gap of a percentage point there is noise.
  • Expecting every country. The grid covers about 100 countries, among them France, Canada, India, Thailand, Egypt and Australia, but not the United Kingdom or the United States.

An AI employee that draws a pyramid for each area

  1. Schedule: once, or once a year for a planning cycle.
  2. Area of interest: your neighbourhoods, drawn or as named places with one radius.
  3. Demographics: totals for each area, with the nine bands.
  4. Data analyst: asked for each band's share in each area, with a bar chart.
  5. Make a report: a PDF with the table and the summary, emailed to the planning team.

The report lands with every area's bands as shares and a short written summary, ready for a meeting. The templates Demographic profile of each city, Who lives in my station's coverage area and Where seniors need home care most use the same age bands for different jobs. For how population fits with places, footfall and traffic in one picture, see location intelligence automation.

Questions

What age bands does the data use?

Nine ten-year bands: 0 to 9, 10 to 19, 20 to 29, 30 to 39, 40 to 49, 50 to 59, 60 to 69, 70 to 79, and 80 and over.

Can I split each age band into women and men?

No. The data gives women and men for the whole area and residents per age band, but not the two together, so the pyramid has one bar per band.

How small an area can I draw a pyramid for?

The figures come from hexagons of about 0.1 square kilometres, so a 500 m circle or a small drawn district works. Very small areas give small, noisier bands.

Can I compare several neighbourhoods at once?

Yes. Put them all in one Area of interest and ask Demographics for totals for each area; each comes back as its own row with the nine bands.

Templates that do this

Read next

More on population and demographics · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.