top of page

You are learning Creating Charts and Graphs in MS Excel

How to create a funnel chart to visualize stages in a process?

Here's how to create a funnel chart to visualize stages in a process using Excel:

Requirements:

* Microsoft Excel 2019, 2021, or a Microsoft 365 subscription (For Windows)
* Excel Mobile or Excel for Android (For mobile devices)

Steps:

1. Prepare your data:
- You'll need two columns of data:
- One column for the stage names in your process (e.g., Leads, Qualified Leads, Sales Calls, Closed Deals).
- Another column for the corresponding values at each stage (e.g., number of leads, number of qualified leads, etc.).

2. Select your data:
- Highlight both columns of data, ensuring they contain the stage names and their respective values.

3. Insert the funnel chart:
- Go to the Insert tab on the Excel ribbon.
- Click on the dropdown menu under Insert Chart (or Chart on mobile).
- In Excel for Windows, you might see an option called Insert Waterfall, Funnel, Stock, Surface or Radar chart. Choose Funnel.
- On mobile devices, you'll find the funnel chart option directly within the chart selection menu.

4. Customize your chart (Optional):
- Excel will automatically generate a basic funnel chart. You can customize it further by:
- Clicking on different chart elements (bars, title, labels) to format them.
- Using the Chart Design or Format tabs on the ribbon to change colors, add data labels, or modify the chart layout.

Tips:

* Ensure your data is arranged correctly, with stage names in the first column and their corresponding values in the second column.
* You can format the data labels to display percentages instead of raw values, providing a clearer picture of the process flow.
* Use colors effectively to visually represent the decrease or increase in values across stages.

By following these steps, you can create a clear and informative funnel chart to effectively visualize the stages in your process within Microsoft Excel.

bottom of page