How to Create Pipeline Chart in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Today, we are going to show two ways to create a Pipeline chart in Excel. Pipeline charts depict the values of a certain parameter or process in a decreasing order. This allows users to see the change or the values at different stages of an operation or different sectors of an operation.


Download Practice Workbook

You can download the practice workbook here.


2 Ways to Create Pipeline Chart in Excel

In this article, we will show two handy ways to create a pipeline chart in Excel. Firstly, we will use the built-in Funnel chart to create the pipeline chart in Excel. Then, we will use the Stacked Bar chart to do the task. Here, we have the sales number of different stores of a product arranged in descending order. We will use this data to create the pipeline chart.

pipeline chart in excel


1. Using Built-in Funnel Chart

In the newer versions of Excel (Excel -2019 or after), users can draw a pipeline chart from the built-in Funnel chart. Here, we will use this option to draw the chart.

Steps:

  • Firstly, select the data in the B4:C10 range.
  • Secondly, select Insert >> Charts >> Insert Waterfall, Funnel, Stock, Surface, or Radar Chart.
  • Finally, select the Funnel chart from the available options.
  • As a result, a chart will be on the screen.

using built-in funnel chart to create a pipeline chart in Excel

  • Now, right-click on the vertical axis.
  • Then, choose Format Axis from the available options.

using built-in funnel chart to create a pipeline chart in Excel

  • Thereafter, go to the Fill & Line section in the Format Axis dialogue box.
  • Next, click on Line.
  • Finally, select No line from the drop-down.

using built-in funnel chart to create a pipeline chart in Excel

  • After that, change the chart title.

  • Now, double click on one of the chart shapes.
  • Then, go to the Home tab.
  • After that, change the fill color of the shape.

using built-in funnel chart to create a pipeline chart in Excel

  • Do the same for the rest of the shapes.
  • Consequently, we will have a well-decorated pipeline chart.

using built-in funnel chart to create a pipeline chart in Excel

This is how we will create a pipeline chart in Excel.

Read More: How to Create a Sales Pipeline Funnel in Excel (with Easy Steps)


2. Using Stacked Bar Chart

In this method, we will insert a pipeline chart by using the Stacked Bar Chart. This is feasible for older versions of Excel ( before Excel 2019). Here, we will create a spacer column which will allow us to give the Stacked Bar chart a pipeline or funnel shape. We will use the MAX function to create the formula for the spacer column values.

Steps:

  • To begin with, click on the C6 cell and enter the following,
=(MAX($D$5:$D$10)-D6)/2
  • Then, hit Enter.
  • As a result, we will have the value for the spacer column.

using stacked column chart to create a pipeline chart in Excel

  • Now, lower the cursor down to Autofill.

using stacked column chart to create a pipeline chart in Excel

  • Next, choose the values in the B4:D10 range.
  • Then, go to the Insert tab.
  • Thereafter, 2-D Bar from the Insert Column or Bar Chart option.

using stacked column chart to create a pipeline chart in Excel

  • As a result, a graph will be on the screen.

  • Then, right-click on the spacer column data series.
  • From the available options, choose
  • Next, set the fill color to No Fill.

using stacked column chart to create a pipeline chart in Excel

  • Now, select the vertical axis and right-click.
  • From the available options, choose Format Axis.

using stacked column chart to create a pipeline chart in Excel

  • Then, from the Axis Options, choose Categories in reverse order.
  • As a result, the chart will turn upside down and resemble the shape of a funnel.

using stacked column chart to create a pipeline chart in Excel

  • Next, right-click on the horizontal axis and click on Delete from the available options.
  • As a result, the horizontal axis will be no more.

  • Now, right-click on the Sales data series and select Format Data Series from the available options.

using stacked column chart to create a pipeline chart in Excel

  • After that, go to the Series Options.
  • From there, set the Gap Width to 5%.
  • As a result, the gap between the shapes will be reduced.

  • Thereafter, right-click on the vertical axis and choose Format Axis from the prevailing options.

  • Then, choose No Line under the Line option of the Fill & Line section.

  • Next, click on the plus sign to the top-right corner of the chart.
  • From the available options, mark the Data Labels option and unmark the Gridlines box.

  • Now, change the color of the fill of the shapes according to the previous method.
  • As a result, we will have our pipeline chart.

In the process, we will get a pipeline chart in Excel.

Read More: How to Create a Sales Pipeline in Excel (with Easy Steps)


Conclusion

In this article, we have talked about 2 ways to create a pipeline chart in Excel. These methods will allow users to present their data in a pipeline chart efficiently and eloquently. If you have any questions regarding this essay, feel free to let us know in the comments. Also, if you want to see more Excel content like this, please visit our website Exceldemy.Com and unlock a great resource for Excel-related content.


Related Articles

Adnan Masruf
Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo