Dynamically Sorted Funnel Chart in Excel - Excel Tips and Tricks Learn how to dynamically sorted create funnel chart in Excel. Create Sorted Table =SORT(B16:C20,2,-1) Insert Funnel Chart 1) Ctrl A 2) Insert ~ Charts ~ Funnel 3) Resize and reposition over Sorted Table Template Funnel Chart 1) Insert ~ Illustrations ~ SmartArt 2) Pyramid 3) Inverted Pyramid 4) OK 5) Resize and reposition 6) Add Shape (2x) 7) SmartArt Style = Flat Scene 8) Fill with gradual fade of greens for each slice Apply Templ

Funnel Chart: Definition and Examples - Statistics How To