Office hacks: quickly create a PPT funnel chart

The clever application of graphics can effectively reduce the text on PPT, and the funnel chart is a good example, which shows the process of data input and output in a vivid way, combining information and visual effects perfectly. To make a funnel chart, we can quickly achieve it through the built-in SmartArt function of PowerPoint, and we can also combine manual methods to make the funnel chart in various forms and personalized.

Create a PPT funnel chart with SmartArt

Start PowerPoint (this article takes 2019 version as an example, 2016 version is also available), switch to the “Insert” tab, click “SmartArt”, and switch to the “Relationship” item in the opened dialog box. In the dialog box that opens, switch to the “Relationships” item, and select the funnel chart on the right. Click “OK”, and then follow the prompts to replace the default text with the content you need, and a funnel chart is created (Figure 1).


Figure 1: Calling SmartArt tool

But we can all simply apply this function, this figure will look the same, next we personalize the above-mentioned basis. First, right-click on the funnel body and select “Set Shape Format”, set it to gray and set the transparency to 0 (because the transparency effect will diminish the three-dimensional effect). To further enhance the three-dimensionality, we can also draw a slightly brighter rectangle and use it as the highlight of the funnel by rotating and “editing the vertices” (Figure 2).


Figure 2 Adding highlights to a three-dimensional funnel drawing

Finally, add a variety of colorful circles to symbolize the variety of ideas collected, and then add a title and text, an image and personalized PPT funnel chart is completed (Figure 3).


Figure 3 PPT funnel chart effect

Flow funnel chart

The above funnel chart with data filtering was quickly created by SmartArt, and on the basis of this chart we can continue to transform it into a flow funnel chart.

Except for the main body of the funnel, delete all other parts, then right-click the arrow below the graph, click “Change shape → Trapezoid” (Figure 4), and then stretch the trapezoid as a funnel mouth and the main body into one.


Figure 4 Change the shape

Next, draw multiple right-angle curved arrows in succession to form a process line, and set a different color from the funnel body to show the difference. Finally, enter the corresponding process text content as well as the decoration, and a schematic diagram of data passing through the funnel filter and then entering the pipeline processing is completed (Figure 5).


Figure 5 Flow funnel diagram

Super cool funnel diagram created by hand


Figure 6 Filtered funnel chart

SmartArt drawing is convenient, but its style is limited after all, like the layer filtering funnel chart shown below, it is difficult to achieve through SmartArt, so we need to build it by hand.

In the above example, each filtering layer uses a different color, and PowerPoint cannot give different colors to the same graph, so we need to disassemble it into multiple graphs and then combine them. The good thing is that each graphic is a similar trapezoid (with arcs), only the size is different.

The production of the basic shape is slightly more complex, first draw an appropriate size of a trapezoid and ellipse, they will be superimposed together, and then execute the “Format → Merge Shapes → Cut” command to get an initial trapezoid (Figure 7).


Figure 7 by merging shapes to get the initial shape

Next, right-click the initial shape, select “Edit Vertex”, the four sides of the graph will appear multiple nodes (black squares), click the nodes and then drag the subsequent anchor points (white squares), you can adjust the curvature of the line at will, to get the basic shape we want (Figure 8).


Figure 8 Edit the vertices to adjust the basic shape

If there is something wrong with one of the primitives, you can right-click on it individually and edit the vertices to adjust it. After the adjustment, give each primitive a different color (Figure 9).


Figure 9: Setting individual colors for each primitive

Finally, we add other decorations and the corresponding text to get the filtered funnel shown in the previous section.


Leave a Comment