Create and Learn Books - a quick and easy way to learn by doing

  • Create and Learn

Creating a Nice Funnel Chart! Excel Create and Learn.

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



1 - Type the data below.




2 - With the cells selected Go to "Insert" tab, "Charts" group, 3-D Stacked Column.




3 - With the chart selected, click in the option "Switch Row/Column".




 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.




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.




6 - Right click the "Vertical Axis" and select "Format Axis". Go to "Axis Options" and check the option "Values in reverse order".




7 - Go to "Chart Elements" and let just the "Legend / Bottom" selected.




8 - Select the series and change the colors as your preferences.




 9 - Select each series and change the "Shape Outline" color to light grey and the weight to 3pt.




10 - If you want you can insert the "Chart Title" and "Data Labels" as the image below.



11 - To give it a "Round Edge" effect, go to "Format Chart Area", "Effects", "3-D Rotation" and set the "Perspective" as 15.




 12 - Congratulations! You have created a Customized Funnel Chart! This is a useful, nice and professional look!


Excel funnel chart pipeline for sales dashboard

If you want to learn more about using charts, shapes and pictures to create visual content, try my book "Dynamic Infographic":

Excel book infographics and dashboards

http://www.amazon.com/dp/B01DVM69LC/ref=cm_sw_su_dp






The 100 Page Book - Python

Uncomplicated and easy to assimilate structure

Python The 100 page book - cover.png

Power BI – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Power BI 2019.jpg

Power BI, Excel and Tableau – BI Clinic

Learn how to create Dashboard using Power BI, Excel and Tableau.

BI Clinic Complete Single cover.jpg

Power BI Academy: HR Recruitment

Create a complete dashboard for Human Resources. Bonus: 10 Templates

ebook.png

Tableau – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Tableau ebook 2019.jpg

Excel – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Excel BI ebook 2019.jpg