How to Create a Funnel Chart in Excel (Sales funnel based on Excel data)

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/sales-funnel-file

[@excelisfun]

Thanks for the funnel fun : ) Great Task Pane Clipboard Trick!

[@LeilaGharani]

Thank you Mike for your support. The clipboard option still helps us to play around with the new charts :)

[@joefromdc]

For me it’s crazy how the help menu for most applications have never been helpful. You and a few other people (excelisfun) are the best excel content providers on KZbin. Finally the reason why most people hated school was because the teachers while knowledgeable couldn’t relay the information in a way that was engaging, informative and easy to understand. Thanks again for all ur hard work

[@LeilaGharani]

Thank you Joe for the kind words and your support of our channels. Your comment made my day :)

[@zeshanashraf6341]

Ma'am you are so beautiful and your face and your voice is so nice i like you and i love u

[@christopherwright361]

Nice idea. It works as long as there is enough difference between each level. For example, if you had left it at 76 and just changed the last one to 40, then the top of the 40 would be wider than the bottom of the 76.

[@sidneyjohnson6895]

Leila, you bring simplicity to complex situations. Your style of teaching is approachable and with ease. Great tutorial!

[@ckokse]

Not a chart I would use at work but it is always amazing to see what one can do with Excel.

[@1gopalakrishnarao]

Thanks to my beloved/beautiful/brilliant/Excellent-- Excel Teacher,. You are making us to become MAD OF EXCEL by your special tricks/tips/tools/techniques/teaching methods. Salutations.

[@LeilaGharani]

Thank you very much Gopala for your support! I'm very happy to have people excited about Excel as much as I am :)

[@AbhishekTripathidce]

I m pretty much enjoying watching your video . You are awesome Leila .

[@LeilaGharani]

Thank you so much!

[@beardog6569]

This lady knows her shit and explains it so clearly

[@sushantjoshi5865]

Great.. clipboard picture trick was new for me.. Thanks

[@LeilaGharani]

You're very welcome Sushant. Thank you for your support.

[@santoshgnaga8540]

Leila madam you're jus fabulous in teaching excel ...No one can beat you...love u alot ...U bring awesomeness to excel God bless you madam

[@vinayazzie4409]

Got the basic idea. Thank you.

[@shraddhayadav5051]

Leila, you saved my career, thanks a gazillion.. love you loads❤️

[@775shahrukh]

how ....?? and where is the gazillion

[@edot2068]

You are simply amazing! Great delivery!

[@ahmadmido9545]

Learn a lot from this channel .. keep upload more fun excel ^ ^

[@wayneedmondson1065]

Hi Leila.. great funnel chart video and cool tip with the clipboard to get different shapes representing the chart series. Your ideas and solutions are always so creative and clever. Thumbs up!

[@LeilaGharani]

Thank you Wayne for your comment and thumbs up :)

[@petemurphy7164]

I always like working through these videos, it really helps with my Excel development. I even did one of Leila's courses on Udemy which led to me getting skilled enough to pass a MOS Excel certification!

[@sarfarajkureshi6569]

Nice video with nice tune

[@LeilaGharani]

Thank you! Glad you like it.

[@ianpetrie527]

Yippie!!! Thank you!!! Beauty in simplicity!!! :-)

[@anshuiway]

I really like this video. I like your channel because your creativity is very innovative and interesting. This type of funnel chart is so good. Thanks to sharing this.

[@LeilaGharani]

You're very welcome Anubhav! I'm glad you like this one.

[@WaqasAli-dq9wg]

I Love such videos...!!!

[@fahadgilani630]

Very nice trick and timely support for my new designing/graphs

[@LeilaGharani]

That's great! Thank you for your support.

[@salongirl77]

Now that’s pretty cool - thanks for sharing 😃

[@amanahemad7828]

Hi, Very helpful video for funnel chart 👍👍

[@LeilaGharani]

Glad you like the video.

[@ozonelayerhole1371]

wow wonderful video

[@MalinaC]

Very clever! I love your charts :)

[@chamindabasnayake4844]

This is amazing, thank you!

[@mohammedMbwana]

As always, brilliant !! Thank you madam

[@LeilaGharani]

You're very welcome. Glad you like it!

[@arunark274]

Wow, lovely as usual 💕💕💕💕💕💕👍👍👍👍👍👍💐💐💐💐💐

[@Xyour_starX]

Thanks, was too innovative.✨

[@Luciano_mp]

A good trick, cool. Thank you Leila!

[@sj6361]

Very useful.

[@RJ-dz1hu]

Thank you so much your content it is always so appreciated. :-)

[@LeilaGharani]

You're very welcome! I'm glad you enjoy the content :)

[@maryamzeeshankhan5810]

I would request for a Split Funnel Chart tutorial video

[@mohmmadabdo5899]

I like it Thank you, pls make more videos about Infographic reports using Exceel skills. 💜

[@LeilaGharani]

You're very welcome. Sure will do :)

[@equinonez55]

Would you please show how to pull data from a Dynamic Table to build a Dashboard. Thank you

[@مقدادحديد]

thank you queen

[@mmincredible1451]

Love ur voice 💐👍

[@eminabdullayev6569]

Thanks

[@yaqubkhan_ayanthenewauthor]

Leila, need your help with Quality control tools. Can you please make videos on those? Really helpful

[@mahenderramanakola1049]

Hi madam l like u r teaching

[@JayantaBora]

Awesome

[@hattan6775]

Thank you 😘👏

[@LeilaGharani]

You're very welcome Hattan

[@balamuniyandi]

Hi Leila,worth to watch this one,can you prepare a pivot table with countries flag?

[@danielhartjes2479]

At time INDEX 4:40 you say to copy the first piece of the pyramid and go to Fill / Picture or texture fill, then click Clipboard. My Clipboard is grayed out for some reason. Any suggestions. Thank you!

[@JonasDeman]

Thank you Leila. Another question on Funnel Charts: how do you place 2 datasets, so 2 funnels, in 1 graph ? For example I have the prospects, contact, initial visits, opportunities and client for the US but also for Mexico and Canada. How do you place (in this case 3) datasets on 1 graph? So 3 funnels next to each other with the same vertical axis? Thanks!

[@peterjmaida2057]

Hi just subscribed. I am slow when it comes to new computer concepts. You seem soooo smart and intelligent. Could you give me some advice on how to start learning Microsoft applications from zero experience. My local library no longer offers free courses so I will have to shell out some dollars at my local Community college. It's not that I need these skills right away

[@LeilaGharani]

Thank you for the kind words. I'm not smart - I've just been using Excel a lot for a long time :) I'm currently working on an Excel basics course, but you can learn for free too. On KZbin & blog posts you'll find plenty of free information - if you don't mind putting the pieces together yourself they're a great source...

[@ZAHIDHUSSAIN-ri5kg]

Very excellent Leila! But unfortunately i don't have office 2016.☺

[@LeilaGharani]

Thank you Zahid. For older Excel versions: you can apply the same trick to a stacked bar chart to get this funnel look.

[@munneysh]

Hi Leila joon. Would you explain how to make a sudoku solver?

[@vignesh6703]

Hi Leila, this video is very helpful for me. Could you please make a video about burn down chart. If you already done a video on this can you please help me with the link of it.

[@LeilaGharani]

Thanks Vignesh. I have this one on my list. Will get to it at some point....

[@vignesh6703]

@@LeilaGharani Thanks Leila :)

[@zztefhanysgs121]

Tengo instalada la versión 2016 , pero no me aparece la opción de gráfico embudo :(. what´s the matter? thanks so much .

[@aradhyamudigonda4513]

How do you create multiple funnel charts side by side quickly with all the data in a single table?

[@HerveMicollet]

Hi thank you for this pretty funnel. Would it be possible to have an horizontal one?

[@sredharbalaraman1387]

Nice

[@blueberrie1317]

Wonder if you can do a sample monthly budget in excel too. Would love to see how you make one

[@LeilaGharani]

I'll think about it. If I can come up with something useful I'll make a video.

[@naqshgarg7625]

Clipboard functionality: the most ignored but so powerful :-)

[@hosseinhosseinpoor4845]

thanks..

[@mostafahassan5021]

Can you please provide me by some information about your current course.

[@DonovanJenkins]

Good info about new vs old chart types. Explains why I can't set the title equal to a cell for a waterfall chart. My workaround for that is to add a shape for the title and set it equal to a cell. Have the problem of 2 separate objects however, and group doesn't seem to work. Any other ideas, anyone?

[@LeilaGharani]

Here is an update from Microsoft: excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/14933598-linking-chart-title-to-a-cell-on-waterfall-charts Please caste your vote so we get it sooner than later...

[@HomeboyHotel]

What happens if Funnel is not available? I can't see it on my excel at work

[@cast6736]

you think you can make a video on PMT

[@swastikaggarwal221]

idk why my excel is not funnel chart !! what to do in this case ? can you help

[@murtazahgm7854]

goooooood

[@anshuiway]

Copy from picture clipboard is too good

[@debasishsahoo4402]

want create this worksheet Can U help me

[@angelclarke1942]

I have office 2016 plus i am not seeing it in excel

[@liza10o]

I don't have this chart type either in my excel

[@luthfiseptiandy5701]

pleass do NPV, IRR chart:)

[@LeilaGharani]

Added to my list. Thank you for your suggestion.

[@luthfiseptiandy5701]

thank you really apreciate

[@TechnoNetworkGuy]

Some Keyboard shortcuts which improves productivity :- kzbin.info/www/bejne/qWa9pmmLpLqims0

[@yulinliu850]

Yeah, data visualisation~

[@LeilaGharani]

Yes....It was about time :)

[@cesarsaldana3429]

very inginius

[@DaivoHelloworld]

:D

[@DaivoHelloworld]

X---

[@whatsupdown4181]

Ur name is Arabic ,u can offer courses in Arabic also. 😁

[@LeilaGharani]

Hi Smail - I don't speak Arabic....

[@whatsupdown4181]

@@LeilaGharani Great but thank u so much for ur courses