This Excel Chart will grab your attention (Infographic template included)

Подписаться 2,7 млн

Просмотров 1,1 млн

50% 1

Master Business Charts in Excel with our course 👉 link.xelplus.com/yt-d-all-cou...
Learn how to create Excel graphs that are different to the norm but still visually effective. They are great to include in special reports and dashboards.
⬇️ Download the workbook here: pages.xelplus.com/special-cha...
We'll cover the dynamic aspect of the chart, highlighting the use of conditional formatting to emphasize the most significant data. This includes dynamically highlighting the weekday with the maximum number of users, ensuring the chart updates automatically with new data. The tutorial guides viewers on how to create shapes within charts and adjust them to prevent distortion, a key factor in maintaining the chart's visual appeal.
Moreover, the video covers advanced techniques such as adding data labels, utilizing stacked column charts, and implementing conditional formatting for rounded column charts. This in-depth guide not only teaches how to visually enhance charts in Excel but also ensures that the data remains dynamic and responsive to changes.
Note: This technique is a part of my online Dashboard course: www.xelplus.com/course/excel-...
🌍 Join 400,000+ professionals in our courses ► link.xelplus.com/yt-d-all-cou...
00:00 Why Create a Non-Standard Column Chart in Excel
01:48 Start with Basic Column Chart
02:44 Conditional Formatting of Excel Column Chart for MAX-Value
05:51 Create Round Shape for Excel Column Chart
07:45 Prevent Stretching of Round Shape in Column Chart
10:41 Add Data Labels to Excel Chart
12:45 Add Conditional Formatting to Rounded Column Chart
This video shows you how to create special (non-standard) Excel graphs or info-charts in Excel. Not only that but it also shows you how you can conditionally format your graph to highlight specific categories. In this example, I show you how to highlight the week day that has the most users logged on to a system, but you can apply the same technique to any other logic as well.
After that, I show you how you can add shapes to charts. This attracts the attention of your readers because it's different to what they are used to seeing. The problem with this technique is that it stretches out the shape for the bigger data sets so depending on the shape you are using, they are no longer harmonized.
As a last step, I show you a trick you can use to create harmonized shapes in your Excel graphs. It's all a matter of proper data preparation before you draw out the chart.
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

Опубликовано:

6 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 1 тыс.

@LeilaGharani 11 месяцев назад

Grab the file I used in the video from here 👉 pages.xelplus.com/special-chart-file 👋 Exciting news! We've released a new, modern Excel Business Charts Course: link.xelplus.com/yt-bizcharts-course

@GPMGify 5 лет назад

Wherever I work I’m considered the Excel Guru. But watching your videos makes me realize that I can still learn so much from you! If RU-vid wouldn’t exist, it would need to be invented just to show your videos! Plus: your teaching skills are phenomenal! Your voice is so easy to follow. I can’t see the slightest room for improvement as your classes are simply perfect!!! Thank you Leila!

@LeilaGharani 5 лет назад

That's really kind GPMGify! Your comment made my day. I'm very happy to hear you find the tutorials useful. I think with topics like Excel, there is no end to discovering new things. I find new things all the time :) Thank you so much for your support.

@Acheiropoietos 5 лет назад

So clever. I have been using Excel for 20+ years and this never occurred to me. So happy I found your channel!

@isoboyehorsfall8270 5 лет назад

This is truly great. I can learn excel while performing the required task. Thanks Leila

@Trancical 3 года назад

Although this post is somewhat old, I do believe Leila has the absolute best teaching style. The content and delivery are first class and the clear instructions are simple to follow. I look forward to learning more and watching this star shine.

@LeilaGharani 3 года назад

Wow, thank you Tim!

@silversam1126 4 года назад

Excellent tutorial! I never considered personalizing my charts and data representations but you make it easier.

@abdulfattahalhazmi2524 6 лет назад

Leila, I am still wondering why your subscriber is relatively low; it is, in my opinion, the best youtube channel explaining Microsoft Excel. So, it deserves millions and millions of subscribers. I really like it, addicted watching it, and enjoying it. Thank you very much :)

@LeilaGharani 6 лет назад

Thank you Abdulfattah for the kind words. I'm glad you like the content and the channel and many thanks for your support. I think it requires a lot of videos to get noticed on RU-vid. So hopefully with time and support from Excel fans like you the channel gets more recognition.

@AimieKunyita 5 лет назад

Right?! I was wondering the same thing.

@ajayv304 5 лет назад

Even I got addicted.

@seekknowledge2714 5 лет назад

@@LeilaGharani After watching one video for you, I too was wondering the same thing as Abdulfattah. The reason in my opinion is because of mixture of expectations, previous experiences and preconceived ideas. not many will tell you this. but I am confident you will see the point i am trying to explain. You are a confident, beautiful, smart lady, and because all your videos are displaying the beautiful big photo of yours upfront, most people's first thought will normally be "she is just another beautiful girl trying to use beauty to compensate for "something" , but that's not what i am looking for now" (meaning she is probably not special in knowledge about excel). Then they skip your video to go for another channel. Its a sad thing, but its true. You cannot blame them for having that thought, because unfortunately images of beautiful women have been over used to market virtually ANYTHING, specially things that otherwise might not be easy to sell. However, it only take ONE advanced excel video to know how good and knowledgeable you are, Laila. Your upfront beauty is unfortunately distracting and "misleading" people :), however. if they only had the patience or the willingness to give you a chance, they would have seen how outstanding is your knowledge and teaching skills. I would personally rate you among the best excel tutors in youtube. If you want, you can try to reduce the photo size to small circle in the corner and see the effect. Many youtubers do it that way.

@coolrup 5 лет назад

The best part of your tutorial is you really teach it with so ease. I must admit I learned so much from your videos!! Thanks again

@abbykrich8 5 лет назад

WoW!!!! Amazing and Inspiring technique. I definitely am going to use it for my future projects. Thank you very much, Leila. I wish you the best!!!

@NQuiz52 5 лет назад

Wow! I love your videos. I am SO Happy to have found you. THANKS!

@sanikanaik944 3 года назад

Simply amazing! Being an Intern I did this entire chart manually 🤦 A huge thanks to you for these amazing videos! Saving the interns lives 🤭

@beaudene2021 5 лет назад

I don't even use excel, but I watched. Fascinating. Keep it up Leila. ^_^

@AimieKunyita 5 лет назад

Leila, this is awesome! I immediately subscribed after watching this video. You're a good instructor.

@christopherschembri7793 5 лет назад

Thank you very much for these chart tips. Excellent! Following your instructions it is now also easy to add a third colour to highlight the minimum value using an additional data set.

@frankbower3731 5 лет назад

This is so ingenious; I'm genuinely impressed. I just gained so much respect for your channel!

@Rubbernecker 6 лет назад

Absolutely brilliant!! I consider myself a fairly experienced Excel user, but I learned a lot from this video! New subscriber!!

@LeilaGharani 6 лет назад

I'm glad to hear that! Thank you for your support.

@sannaing7043 3 года назад

I cannot thank you enough for sharing such excellent excel tips to create dynamic charts. I learnt a lot from watching your videos. Thank you.

@excelisfun 7 лет назад

That is just awesome!!! : ) I love it: Just copy and paste shape into chart!!!! Thank you for that trick and the many other tricks in this video!

@LeilaGharani 7 лет назад

Glad you like it Mike! It's just fun to play around in Excel. So many possibilities :)

@excelisfun 7 лет назад

I happily agree : )

@msaikat100 3 года назад

Big fan of both

@coinmarketcharts7276 2 года назад

Awesomeness togeather!

@tokunboomonubi4329 6 лет назад

I applaud and tip my hat off to you madam. That was awesome. I half expected you will talk about some kind of plugin that would help but this is some really good application of knowledge

@LeilaGharani 6 лет назад

Thank you! I'm glad this helps. I always prefer using Excel before any plugins....

@zackchew5874 4 года назад

Leila, watched many of your videos and am always amazed. Loving and appreciate everything.

@cre8tivetoy 3 года назад

I was lucky to full upon your RU-vid channel and learnt so many things. I now use a number of your lesson to make my Excel data easier to use and display. Thank you.

@johannyjacobsen9208 5 лет назад

Wow! I also agree that this is the BEST Excel Toutube channel ever

@LeilaGharani 5 лет назад

Wow, many thanks for the kind words Johanny!

@petemenhennet9792 5 лет назад

Great-looking Excel chart and a well-presented tutorial, clear and easy to follow. Well done.

@Gunaha007 4 года назад

Leila, Wonderful depiction, with no stumbling in between which makes your video on Excel charts amazing. Keep up the good work and surely the views are increasing day by day.

@umranshahid 4 года назад

This is Umran from Pakistan. Thank you very much Leila. I regularly watch your videos. You really have a good command over MSExcel. Your method of explaining any formula is very good. You elaborate everything in a clear way. I have used the functions/formulas learnt from your videos and highly appreciated. All this is due to due to your proper guidelines. Thank you very much indeed!

@craigwatkins7275 7 лет назад

About a month ago, my job responsibilities changed. I now had to use Excel to track all kinds of metrics. I had NEVER used Excel, so I was overwhelmed to say the least. I resorted to RU-vid searches to help me. Within a week, I had people asking "you did that in Excel?!". Your videos have helped me in such a great way - and I am now the "go to" guy when people have Excel questions. Obviously I don't know everything about Excel, but I know I can either figure it out - or "research it" in You tube! Your training videos ROCK!

@LeilaGharani 7 лет назад

Craig - this makes me really happy! There is a great Excel online community out there and I am very glad to be part of it. The great thing about Excel is that, there is no end to learning. Every situation is unique and needs it's own sets of knowledge and skills. Every task is a puzzle. I for sure don't know everything about Excel and like you I'm figuring it out together with the help of all the other Excel enthusiasts out there. Your comment made my day. Thanks!

@munna141079 5 лет назад

You are "FLAWLESS"

@abdiwahidabubakar 4 года назад

Every video I watch from your channel makes me excited. Thank you for making these great tutorials.

@KaldaneAnswers 4 года назад

Your lessons are very inspiring. I take a lot of notes from here while making my videos.

@MrGeralt53 6 лет назад

Great video! I've been following the tutorial while using the sheet. I've encountered a problem when I got to the part where there are the stacked columns. When I try to change the top with the curved shape, there's a gap between the curved shape & the lower column. How do I solve this? I'm using Excel 2011 for Mac.

@paulcosser9196 6 лет назад

I found the same problem?

@kenbee1957 5 лет назад

Civ V account pic I dont know why that is making me very happy

@nesao007 5 лет назад

Dear Leila, Ive been looking at several online Excel sessions during the last week (e.g. Excel is fun etc), you are far the best one and the most beautiful! :-) which is helping to stay focused!

@kylelane630 3 года назад

I've just created this, and it's fab! I've also set one up with the top 3 highest highlighted, and also one chart with just the top 2 highlighted, using nested if statements with either the LARGE(array,3) or LARGE(array,2) in.

@Munki 4 года назад

Wow what a great tutorial! I've started implementing these kind of visualisations into my dashboards at work and they've been really well received. Thank you so much!

@LeilaGharani 4 года назад

It's great to hear that it was useful and you could apply it at work Michael.

@kasunsuraj2942 4 года назад

At last I found the most clear and most understandable excel tutor in youtube. Hats off, you are truly amazing. May God bless you with his showers of wisdom. Thanks a lot for sharing your knowledge with everyone in the world.

@LeilaGharani 4 года назад

My pleasure. Thank you for the kind feedback.

@NarendraPaiG 3 года назад

I have worked in excel for long.. but copy pasting that object on a series is a thing - I never knew in last 15 years.. Great info... The color formatting is also new to me, in a graph... Keep educating...

@EricaDyson 5 лет назад

Ditto to Abdulfattah's comment. Fantastic. And thanks so much for the workbooks. Really excellent!

@ShomeSengupta 6 лет назад

Excellent! one of the best Excel tutorials. Not too fast, not too slow

@dineshsharma5478 3 года назад

Hii.. Leila your tutorial are really really helpful for me , I really imporved my excel skills in this lockdown please. Keep posting . Thanks

@NN-pl2rr 5 лет назад

Amazing techniques. Loved it! Thanks Leila.

@Merinkroft 5 лет назад

I was just randomly browsing youtube and found that video by chance. Your video just easily won the competition and i couldn't stop watching it. Great work, I cannot wait to show my new improved excel skills at work!

@LeilaGharani 5 лет назад

That's great! It's nice you took the time to watch an Excel video instead of all the other fun stuff on RU-vid :)

@dipayanroy1036 6 лет назад

Leila, thank you so much for your all tutorials. Your tutorials helped me a lot. Can't thank you enough

@LeilaGharani 6 лет назад

You're very welcome. I'm really happy to hear you find the tutorials helpful. Thank you for your support.

@kangsungho1752 5 лет назад

Always appreciate your creative and incredible ideas!

@kurttruk2 6 лет назад

That was an excellent and easy to understand tutorial video. Thank you!!

@gabbarsingh3857 4 года назад

Thanx a ton...I wonder how beautiful a data chart could be. I recently started learning Excel and got more fascinated by ur tutorials.

@manjulunierasto5156 5 лет назад

This single video made me subscribe your channel, you know how to teach..thank you very much. I hope i will learn more and more. ~From Tanzania

@sandarmyint4011 Год назад

Thanks a lot. I get many things from your teaching.

@jacobmartin3088 5 лет назад

Amazing, i loved it, Thank u very much Leila👍👌

@anillpatel 6 лет назад

You're too good Leila. Your videos are so exciting to watch. Great techniques which we can literally implement in our business.

@LeilaGharani 5 лет назад

I'm glad to hear it is helpful in your business!

@MrLeicesterian 2 года назад

Hello Leila, I have just started using Excel, mainly for personal use, and this is the first one of your videos I have followed step by step. Although there are some differences with Excel for Mac with regards to displays and windows I managed to achieve the same result. Definitely a chart to keep hold of for future use thank you.

@LeilaGharani 2 года назад

Great to hear, Richard!

@coreydogpound 5 лет назад

Excellent. I have only watched a few videos so far, but you have given me several new tools for my Excel toolbox. I love your very natural way of teaching how it works while showing me what to do.

@LeilaGharani 5 лет назад

Glad you find the videos helpful. Great to have you here!

@shilpachouhan6840 2 года назад

You are awesome !! thank you so much ,your videos are so informative and the way you explain makes them so easy to understand .Really appreciates all your efforts making such great content 🙂.

@shyammishra2365 4 года назад

I have been watching your videos for a long time and I feel you are amazing maam

@GarthShaner 5 лет назад

This is great! Love the (relative) simplicity of how you made the boring chart eye-catching!

@LeilaGharani 5 лет назад

Glad you like the tutorial Garth!

@waqarshaikh86 4 года назад

Thanks a lot for this wonderful tutorial. I manage to get this chart made just in couple of minutes and even incorporated Minimum Value Bar in Red through the logic you have explained. It looks amazing.

@LeilaGharani 4 года назад

That's great! Glad you could implement it right away.

@walidelmallah1167 4 года назад

Leila, You are the best one who represent the best and efficient ideas in Excel. Thank you very much

@TheShambru 3 года назад

Awesome Leila! The commitment and passion to make your work stand out!! totally worth it. Thanks a tonne! You are a genius. Lots of love and gratitude from India

@LeilaGharani 3 года назад

Thank you so much!

@stephenbrincat7124 5 лет назад

Wow nice chart and good explanation, will definitely use ;)

@comichosofrianoluis9105 4 года назад

I don't have enough words to describe how your channel is helping me in my career of Business Analyst. Thank you for all the content that you have been posting. I'm writing from Mozambique in Africa. May God keep blessing your life so you can keep teaching us.

@LeilaGharani 4 года назад

I'm very happy the content is helpful. Greetings to Mozambique!

@piotr4248 4 года назад

Very impressive! Thank you so much for sharing your skills.

@lahotiamitk 4 года назад

Wow! ..and this is explained such amazingly simple way that even my 10 year old son could do it.. he has very limited knowledge of excel, with almost nil exposure to charts... still he could do, all his own! Great 👍👍

@shahidstate82 4 года назад

Being using excel for almost 18 years I never see these magic, thanks a lot and proud of you.

@LeilaGharani 4 года назад

Glad you found something new!

@alirezataghipour4834 5 лет назад

Dear Leila, It was perfect. Thank you for sharing.

@gerrythomas6297 2 года назад

You are the best! Thanks for sharing your knowledge!!

@SeamusHarper1234 5 лет назад

dl;dr: Love the video. THIS is how Bar Charts look like out of the box... I am surprised how little Excel Charts have changed visually over the time. You can easy do charts with a library like chart.js that are so much more appealing, but it seems you can do some good in Excel itself with the right buttons!

@mrsmrk0771 5 лет назад

Many thanks Leila for this tutorial, amazing and very clever trick! I will follow you for your full Excel dashboards course!

@LeilaGharani 5 лет назад

You're welcome! Thanks Mirko for your support.

@ninobrn00 5 лет назад

I LOVED this tutorial! I cannot wait to use it in one of my products. Thank you so very much. I'm subscribed and will try to do these lessons justice.

@LeilaGharani 5 лет назад

Thank you for your feedback and subscribing.

@BinhTran-bc2rp 3 года назад

your videos are inspiring me to excel a lot. Thank you, Leila

@LeilaGharani 3 года назад

Happy to hear that :)

@theCrankyYankee 6 лет назад

Really well done. I've been using Excel since Excel 5 and I still learned something new! Keep up the great work - you've got a new subscriber!

@LeilaGharani 6 лет назад

Thank you for your nice comment & the sub. Glad you found something new here.

@arbiantosetiawan 3 года назад

Thanks Leila. Really appreciate it. This is really great. Keep on doing it!

@saptharishi1974 3 года назад

Just brilliant. Thank you so much, your content delivery is beyond par excellence - crystal clear explanations!

@LeilaGharani 3 года назад

Thank you!

@siddharthsaini9972 6 лет назад

I learnt many important tricks from your videos. Thanks for uploaded your video and trained to everybody.

@Robert8455 5 лет назад

Hope you don't think this is too corney, but I think you are visually appealing and you have my attention. Seriously, I enjoy your videos, you have great excel tips and tricks and have a soothing presentation quality. I've been using excel for a really long time but decided to sharpen up my skills and learn what the newer versions can do and I am so glad I found you!

@LeilaGharani 5 лет назад

I'm glad you like the videos Robert.

@Amr-Ibrahim-AI 6 лет назад

Hey. This is really great. I like the way you think and the way you explain.

@prince4x4 5 лет назад

Thanks for your tutorials, help us a lot.

@makisalimhussain2334 3 года назад

Fantastic ideas especially copy and paste bar shape. Thank you Leila. 👍

@Mahendrababu56 6 лет назад

Leila, You are doing Best, Keep doing that,We are here to learn

@s.miller7444 4 года назад

Great tutorial. Thanks, will be following your videos, DEFINITELY!!

@jamietan8002 4 года назад

Thank you so much. This one is powerful.

@gabormathe823 7 лет назад

marvelous! one of the best tricks&tips videos i've ever seen! thank you!

@LeilaGharani 7 лет назад

Glad you like it Gabor.

@SuperWolfkin 7 лет назад

excellent technique. Subscribed just in case you do more that I find compelling.

@LeilaGharani 7 лет назад

Glad you like it!

@akthad 5 лет назад

Thank you !!! Great tips on charts, very good idea on getting the "max" to stand out! Thanks!!

@LeilaGharani 5 лет назад

You're welcome! Glad you like it.

@wellsnapyeah 5 лет назад

Wow, I learned a bunch. Thank you.

@shirleysmith3409 5 лет назад

Wonderful Excel skills, it's been a long since I have seen something more clever and interesting. Congratulations and thank you! Keep it going.

@LeilaGharani 5 лет назад

Thank you Shirley. I'm glad to hear that!

@arunastamosauskas4860 5 лет назад

Impressive, practical, outstanding. You are the best Excel teacher in YT. Thank you very much for sharing these lessons.

@LeilaGharani 5 лет назад

That's very kind. Thank you Arunas.

@pushpajchougule8316 4 года назад

To be honest i have watched N number of excel videos on youtube but this caught my attention. It was so prompt that this video made me eager to learn this and try couple of times for practice right away. Gonna watch all your videos soon. Please do not stop doing what you are doing now!

@LeilaGharani 4 года назад

Glad to have you here!

@hozkaras Год назад

It was a useful lesson. It was something I was wondering about, thank you for the lesson.

@davidnorth4703 7 лет назад

Leila, you are amazing and it shows that it's never too late to learn new tricks. Thank you x

@LeilaGharani 7 лет назад

Thank you & you're welcome David. No one can be too old for Excel :)

@Normambo 4 года назад

That was a series of neat tricks to get this amazing differenciation in graph presentation. Bravo! Keep bringing them forward. Norm from Montreal

@LeilaGharani 4 года назад

Glad you found something useful Norm.

@kimfucku8074 6 лет назад

You are at the top of my charts!!!

@edwarddurant9205 2 года назад

One of the best youtubers when it comes to excel help!!

@waizwaidarenosa9032 4 года назад

Thank you Leila. That was one of the best lessons I had so far.

@LeilaGharani 4 года назад

Wow, that's great!

@jayhshah8 5 лет назад

Thanks for all your efforts. Really I didn't know Excel could do this.

@felixgar1000 Год назад

Greetings from Perú! i love your classes

@alexrosen8762 7 лет назад

Wow! Great stuff. Thank you from Sweden :-)

@jorgezavala5512 5 лет назад

i was so happy to finally know how to make this charts!! thank you so much

@LeilaGharani 5 лет назад

You're very welcome Jorge. Glad the tutorial is helpful.

@s.anandtnfu6798 4 года назад

Excellet explanation.. really helpful for learners to know how best to present their data

@pravinshingadia7337 4 года назад

You're videos are amazing! I'm a new subscriber but learning lots.

@aatikaferozali641 3 года назад

I recently started using Excel as part of my university course and your videos really helped me in my Assignments and Exams. Thank you so much for all the help.

@LeilaGharani 3 года назад

I'm happy to hear that, Aatika.