Funnel Chart can be very useful to show stages and proportions in the sales process. Despite its importance, creating a nice Funnel Chart in Excel can be little tricky. In this step-by-step you will be able to create a nice one, following the example below.
![Excel funnel chart pipeline for sales dashboard](https://static.wixstatic.com/media/6ef6a7_f6d6aee4ac06486a9a588117ff14edd0~mv2.png/v1/fill/w_51,h_42,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_f6d6aee4ac06486a9a588117ff14edd0~mv2.png)
1 - Type the data below.
![](https://static.wixstatic.com/media/6ef6a7_3479fe7b2f0049768485c465f7b6cdbb~mv2.png/v1/fill/w_69,h_46,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_3479fe7b2f0049768485c465f7b6cdbb~mv2.png)
2 - With the cells selected Go to "Insert" tab, "Charts" group, 3-D Stacked Column.
![](https://static.wixstatic.com/media/6ef6a7_765013255fbf4e1bb675c1341dbb4aac~mv2.png/v1/fill/w_49,h_26,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_765013255fbf4e1bb675c1341dbb4aac~mv2.png)
3 - With the chart selected, click in the option "Switch Row/Column".
![](https://static.wixstatic.com/media/6ef6a7_0d3e67d505f34465b89ae50ea03f1ced~mv2.png/v1/fill/w_60,h_55,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_0d3e67d505f34465b89ae50ea03f1ced~mv2.png)
 4 - Right click the Vertical axis on the chart and select "Format Chart Area", Select "Effects" and change the "X Rotation" and "Y Rotation" to "0" as the image below.
![](https://static.wixstatic.com/media/6ef6a7_cd1d17b055d64fbf8441bc23ede96df5~mv2.png/v1/fill/w_86,h_44,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_cd1d17b055d64fbf8441bc23ede96df5~mv2.png)
5 - Right Click any Series (bar items) and select "Format Data Series". Go to "Series Options" and  set the "Gap Depth" to 150%, "Gap Width" to 80%, and select the "Full Cone" option.
![](https://static.wixstatic.com/media/6ef6a7_9dc4ee3c07984e26b40ca0a1f633d873~mv2.png/v1/fill/w_85,h_49,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_9dc4ee3c07984e26b40ca0a1f633d873~mv2.png)
6 - Right click the "Vertical Axis" and select "Format Axis". Go to "Axis Options" and check the option "Values in reverse order".
![](https://static.wixstatic.com/media/6ef6a7_aa7e501881354e08b3e6d9b229bb6873~mv2.png/v1/fill/w_81,h_50,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_aa7e501881354e08b3e6d9b229bb6873~mv2.png)
7 - Go to "Chart Elements" and let just the "Legend / Bottom" selected.
![](https://static.wixstatic.com/media/6ef6a7_20ea7af162794949a15099b84017697a~mv2.png/v1/fill/w_49,h_16,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_20ea7af162794949a15099b84017697a~mv2.png)
8 - Select the series and change the colors as your preferences.
![](https://static.wixstatic.com/media/6ef6a7_34a3fa31e080441f8a861cb3b8f7e003~mv2.png/v1/fill/w_125,h_110,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_34a3fa31e080441f8a861cb3b8f7e003~mv2.png)
 9 - Select each series and change the "Shape Outline" color to light grey and the weight to 3pt.
![](https://static.wixstatic.com/media/6ef6a7_fa0a25c582e24f93a9c436850eb527da~mv2.png/v1/fill/w_49,h_27,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_fa0a25c582e24f93a9c436850eb527da~mv2.png)
10 - If you want you can insert the "Chart Title" and "Data Labels" as the image below.
![](https://static.wixstatic.com/media/6ef6a7_744167bdcfea4ed88f6e51658720ba5c~mv2.png/v1/fill/w_46,h_21,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_744167bdcfea4ed88f6e51658720ba5c~mv2.png)
11 - To give it a "Round Edge" effect, go to "Format Chart Area", "Effects", "3-D Rotation" and set the "Perspective" as 15.
![](https://static.wixstatic.com/media/6ef6a7_7ba50bbc2999445cb45bf5d63bdb977e~mv2.png/v1/fill/w_66,h_154,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_7ba50bbc2999445cb45bf5d63bdb977e~mv2.png)
 12 - Congratulations! You have created a Customized Funnel Chart! This is a useful, nice and professional look!
![Excel funnel chart pipeline for sales dashboard](https://static.wixstatic.com/media/6ef6a7_a7b8c6af5d8340ce928eeef54401edf0~mv2.png/v1/fill/w_51,h_42,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6ef6a7_a7b8c6af5d8340ce928eeef54401edf0~mv2.png)
If you want to learn more about using charts, shapes and pictures to create visual content, try my book "Dynamic Infographic":