Tuesday, February 7, 2017

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.







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!


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


Please, remember to share :)





2 comments:

  1. Your blog is so nice, and the article is very good it helps to so many people.Advanced Excel Training in Hyderabad

    ReplyDelete
  2. Excellent tutorial. Thank you for going into exact detail/screen shots.

    ReplyDelete