Article title plus a GIF of a funnel animating in layer by layer
Article title plus a GIF of a funnel animating in layer by layer

How to create a funnel diagram quickly

A funnel diagram is great for highlighting the different steps in whittling down a large number to a small number. Perhaps it’s how you deal with job applicants. Or how you convert website viewers to converted customers.

An example of a funnel diagram, and an alternative option with labels inside the diagram layers. This uses recruitment as an example.

And although they might look tricky to draw, you can very quickly convert a SmartArt into a funnel in a few steps. The video below walks you through how to do this - and see the step-by-step guide below. You’ll use two functionalities you may not have used before: Convert to Shape and Edit Points.

Step 1: Insert a pyramid SmartArt

We don’t usually recommend using SmartArt. But in this case, we are going to use the SmartArt Inverted Pyramid as a base then customise it. Before you start, determine how many steps there are in your process.

Go to Insert > SmartArt
Choose Pyramid from the list on the left, then Inverted Pyramid.

Step 2: Configure the layers

You will need one layer for each stage in your process, plus one extra - you’ll see why in a moment. 

Use the text pane to add lines to the bulleted list. If the text pane isn’t showing, turn it on in the SmartArt Design tab.
You can label the steps here if you want to, or label them later.
For the extra layer – which is the point at the bottom of the pyramid – just type a space, as this doesn’t need any text on it.

Step 3: Convert to a shape

Now that we’ve used the SmartArt to create the layers, we can dispense with the ‘smart’ aspect. We’ll turn the drawing into normal shapes that we can then edit. 

Select the SmartArt
On the SmartArt Design tab, click Convert > Convert to Shapes. (Or you could use Ctrl+Shift+G/Cmd+Option+Shift+G to Ungroup, which achieves the same thing.)

Step 4: Turn it into a funnel

The last step is to tweak the bottom triangle to be the nozzle of the funnel. This uses the hidden-away Edit Points function. You can actually use this on any shape when it doesn’t quite meet your needs.

Animation of using the edit points functionality
Select the bottom triangle.
Right-click and select Edit Points.
Select the lowest point and drag it down to stretch the triangle into more of a nozzle shape. This will reveal another edit point underneath.
Select the other bottom edit point and drag that down. Move them both until you have a funnel shape.

You could either have a horizontal funnel, or use an approximate 45° angle. We think the angle looks better and is also easier to draw, since you have to do this by eye – so achieving a perfect horizontal bottom edge is tricky. Whereas no one is going to question the angle you choose.

Finish up: format and label it

Now you can resize and colour the funnel as you need, and decide how to label each layer. We often use separate text boxes to one side, so you don’t have to deal with the issue of the layers getting narrower. 

If your labels do fit inside the funnel, then check the font size – SmartArt will have automatically scaled the text to fit, and it might end up at a size that doesn’t match your document. You might also need to get rid of the text margins that SmartArt calculated.

If you want to draw attention to the flow, you could add some arrows. The arrows in the Microsoft icon set work well for this. (Insert > Icons > type ‘arrows’)

You can even add a droplet of liquid coming out of the bottom of the funnel and label with whatever the end result of the process is. Again, there's a great inbuilt icon for this. Just search for 'drop'.

Do you want to learn how to improve the quality of your documents so that they reflect the quality of your thinking? Talk to us to discuss how we can help.
Get in contact
Published:
December 22, 2023

JUST launched: Online Self-STUDY LEARNING

We've created our first online course: How to create a great plan-on-a-page. It covers:

What to put in a plan so it is clear and helpful to your audience
How to make it look high quality – so that they trust it
Plus tips and tricks for using PowerPoint features to draw it
A graphic of a plan overlaid onto a maze

How to create a great plan-on-a-page

View the course

And to accompany the course we have built a new Plan-on-a-page kit:

114 ready-built timelines to paste into your deck, each with custom drawing guides and pre-sized task shapes.
A 'sticker book' of useful shapes to help you quickly build clear, flexible and impressive plans that fit seamlessly into your stakeholder update decks
Works in both inches and centimetres
Picks up your template styles automatically
A series of images of the pages available within the plan kit

How to create a great plan-on-a-page

View the KIT

They are available separately, but you’ll save if you buy them together.

Use LAUNCH25 for 25% off both products. Valid until end 2024.
Use LAUNCH25 for 25% off both products. Valid until end 2024.