3 REALLY Useful Excel Chart Tips You May Have Missed

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Uncover the secrets of efficient Excel chart creation with this tutorial. These are the 3 most common Excel chart questions I get. Perfect for Excel users of all levels, this video offers easy-to-understand guidance and practical tips.
⬇️ Grab the workbook here: pages.xelplus.com/chart-tips-...
Here's what you'll learn:
▪️ Tip 1 - Prevent Chart Disappearance: Discover how to keep your charts visible, even when the data columns are hidden or grouped. Learn a simple setting adjustment to ensure your charts always remain in sight.
▪️ Tip 2 - Snap Chart to Grid: Find out how to perfectly align your charts with Excel's grid. This tip reveals a handy keyboard shortcut and a setting check to make aligning charts a breeze.
▪️ Tip 3 - Integrate Shapes into Charts: Learn how to enhance your charts by adding text boxes or shapes directly. This trick teaches you how to insert shapes that move with your chart, avoiding the need for grouping separate objects.
🌍 My Online Excel Courses ► www.xelplus.com/courses/
★ Links to related videos: ★
Chart basics: • Excel Charts & Graphs:...
➡️ 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

[@LeilaGharani]

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

[@natalievo9576]

Snap to grid is new to me, as well as the stop the disappearing chart. Thank you.... a precious lesson, as always. I really love these short tips as it's something I can apply immediately to my daily usage. Thank you again.

[@LeilaGharani]

Glad you enjoyed it!

[@ubaidyaseencubaidyaseenc8207]

1. Creating shapes and adding text 2. Short cut key of alt+f1 3. Grouping and selecting options These are new to me Well done 👍

[@mattias5063]

Thank you as always, number 1 tip was something I´ve always been annoyed about but never bothered to google - so you saved the day for me, great tip. :)

[@dabizness6662]

I knew none of them 😳. Great tips Laila, especially the last one because now i can create my own custom title / legend to charts. Thanks.

[@LeilaGharani]

You're very welcome Farooq. I use that one a lot too.

[@tiyu3504]

So far these are the best Excel classes I've ever had! Bought your data dashboard class and looking forward to your new packaged classes!

[@LeilaGharani]

I’m really happy to hear you find the tutorials useful. Thank you for your support of my courses.

[@sandeepreddy7687]

Thank you very much Leila. Your sessions are really trustworthy and I hope, I will expect many more from you. Thanks again😊

[@LeilaGharani]

You're very welcome Sandeep. Will do my best to keep it up :) Thank you for your support.

[@alfsilva]

Excellent video Leila, I didn't know tips 1 and 3 and tip 2 not always available in my mind, good to be reminded of it.

[@AussieDropBear]

Love is how I describe Excel, Leila and her videos. Your videos make me look like a star in the workplace. Thank you.

[@LeilaGharani]

I love that! Thank you Jed for the nice comment. Using the stuff learnt is actually the difficult part - well done!

[@anujain654]

I felt like I knew most of the options in Excel. But whenever I watch your videos, it shows a new tip and makes me realise that there's so much more to learn.

[@LeilaGharani]

Great to hear!

[@ckokse]

I like to keep my spreadsheets clean and use grouping a lot. However, I had lots of issues with disappearing charts because of that. THANK YOU for this tip!

[@PK-il3um]

Thanks for these tips. I do a lot of charts for many years and had these problems, solved from now on

[@johnwait345]

My number one top is telling more people about you. I'm good in excel, but I learn a lot from you. I knew about the first tip. But I counter it can also be a feature when using filters. You can turn on and off data without losing the whole chart. This is really valuable when looking for trends in XY plots. Now if you have a tip for preventing the chart from being resized...? The second tip is awesome. I always cut and paste the chart to snap it to a cell. And I use snap to grid all the time in PowerPoint, so duh, it's obvious now, but thank you. The third tip I always have to relearn when I copy and paste a chart somewhere else and objects don't come with it. Errrr! Even when you've clicked a chart it's easy to click off it.

[@LeilaGharani]

Thanks for your feedback, John!

[@persaq]

Perfect tips, thanks Leila.

[@excelisfun]

Thanks for the charting tip fun, Teammate!

[@LeilaGharani]

You're very welcome Mike :)

[@koengsinghz]

Hi there! I knew Tip no 1&2 but 3 is quite useful. I was wandering if you could help me. I have two line charts (the intermingling type not one top of the other) and I want to draw vertical lines between each line charts for each data points. The drop lines go all the way down to the x axis; but I want the drop line to remain point to point. And I want data labels for this gap lines too. Is there a way to do this im excel 2007 or above. Plz help!. E.g. Plz imagine this as vertical line between two points in two line charts. ¤-----¤. 2.5------4.7 So I want the gap 2.2 displayed as well. Thanks in advance!

[@theCrankyYankee]

Brilliant, Leila - thank you for sharing!

[@LeilaGharani]

You're very welcome Gino.

[@lynxwomancat]

Wow! Awesome tips! Two of them I had not heard of before today! Thank you, Leila!

[@LeilaGharani]

You're very welcome Sandy! Glad you find the tips useful :)

[@shadrackawunyo7786]

Excellent Leila. Hidden columns settings are new to me. Good to add additional tips from the other 2 tips to my library

[@LeilaGharani]

I'm happy you found some new tips. Yes - the hidden columns one is a bit tricky to find.....

[@ahmedmohsin9446]

All of the three are new to me, thanks a lot

[@pascalmatthewowor9073]

Very new. I love your class, Professor. Take care.

[@reeseinny]

The last tip was new. Thanks!!!

[@dianacampbell6336]

All 3 were new to me and very useful too. Thank you, Leila.

[@LeilaGharani]

My pleasure Diana.

[@whatsupdown4181]

Thx for your smooth course.

[@PaulVass1]

Hi Leila, all three tips were new to me. Thanks for sharing.

[@LeilaGharani]

You're very welcome. Thank you for the support.

[@Sal_A]

Thanks for the pro tips. Tip 1 and 3 were new for me.

[@LeilaGharani]

You're welcome. Glad you found something new here :)

[@____----____----____]

Simpele but super useful tips Leila! I did’nt know any of these three...

[@jrobinson8898]

These were all new to me! Thank you so much !

[@LeilaGharani]

So glad!

[@SaurabhAgrawal32]

All three are very good, I wish I had known the first one before. However better late than never. Thank you very much Leila for all these amazing videos. I am learning a lot with these. Million thanks. 😊

[@LeilaGharani]

You're very welcome. Agree - better late than never :)

[@lite9027]

All of them are new and super useful. 👍

[@johnford8931]

Thanks for the tips. They were all new to me.

[@theenlightened1s]

Your videos are just great.. I click the Like button before starting the video just to get it out of the way because I know I will have to do it.. thanks for your hard work.. you make Excel fun

[@kaaa3485]

Wow This is great!!!!! you are amazing and an ocean of knowledge. I have being using excel for ever and I feel I'm just scratching the surface. please, keep posting your videos. Thank you so much.

[@LeilaGharani]

I'm glad you find these tips useful. I've been using Excel forever too and I still feel like I don't know half of it!

[@ismailismaili0071]

great the one new to me is the hidden rows or column thank you so much Ms. Leila

[@LeilaGharani]

Glad you found something new Ismail :)

[@weeyewtiong9622]

Awesome. Especially the first tip able to resolve most of my charts issue when data needs to be hidden. Thank you.

[@LeilaGharani]

That's great. I'm happy to hear you find the tips useful.

[@peternganga9371]

Thanks again. Wonderful.

[@KashifMehmood77]

Enjoyed it. All new to me. Thank you.

[@shoaibahmedsagar]

thanks a lot for everything. you enrich our knowledge by delivering such awesome videos. thank you very much

[@LeilaGharani]

It's my pleasure! Thank you for your support of my tutorials.

[@tinothepilot]

Thanks! Didn’t know these ones. Always looking for more to learn.

[@LeilaGharani]

Hope these tips will come in handy for you.

[@rienthongw]

Excellent. Leila, thanks for sharing.

[@LeilaGharani]

You're very welcome :)

[@miplus1]

You are amazing, the three tips were new to me. Thank you!!

[@LeilaGharani]

My pleasure. Glad you found something new.

[@technicalarun7641]

Thanx for sharing such great tips

[@phungquyen3511]

Brilliant. More chart tips, please!

[@ladgrdctd]

Excellent tips! I did not know how to do any of these 3 before watching the video. Very helpful! Thank you!!!

[@LeilaGharani]

Glad you find these helpful :) Thank you for your feedback.

[@GregSocoolski]

Very useful, thank You

[@babarafridi6944]

This is new for me... thank u

[@santsangwornrachasup6613]

Thanks for the tips. This is so simply effective.

[@LeilaGharani]

You're very welcome. Glad you like it.

[@DougHExcel]

Thanks for sharing the tips!

[@LeilaGharani]

You're very welcome Doug :)

[@jollyjoy2734]

Beautiful tutorial

[@peterbriggs2771]

The last trick was new to me I always just grouped to objects as one. Always clear and accessible videos.👌

[@LeilaGharani]

Cool, thanks!

[@mazinmmmmmm]

Thanks for these tips Leila, that's awesome

[@LeilaGharani]

You're so welcome!

[@masoods7841]

Excellant trick.......always rocked thx for sharing

[@fataibamidele]

Thanks for sharing. All new to me

[@samuelkodjoe1645]

all three new to me.....that was awesome....thanks!!

[@LeilaGharani]

Glad you enjoyed it!

[@anandsharma4627]

Yes this new to me, and really very helpful. Thank you so much for the video

[@LeilaGharani]

You are so welcome!

[@nadermounir8228]

Great tips 👌

[@user-bz7fj1fk2m]

Thank U so muchhhhh!!!! Vital!!!

[@chamindabasnayake4844]

Adding a shape into a chart is very cool, Thank you.

[@LeilaGharani]

You're welcome Chaminda. I use that one a lot actually..

[@vijayalakshmidevadiga1714]

Tip 3 was new to me, thanks

[@marhabaturkey6899]

Excellent..

[@vsrblr]

Thanks a ton

[@DDH40228]

Tips 2 and 3 were very helpful, Thanks !

[@LeilaGharani]

Glad the tutorial is helpful.

[@mevartson164]

You are a great excel teacher ma'am. Thank you very much

[@LeilaGharani]

Thank you! 😃

[@ckokse]

Very useful, many thanks Leila!

[@LeilaGharani]

You're very welcome.

[@alexrosen8762]

Your tutorials are just amazing I must say

[@LeilaGharani]

I'm glad you like them Alex :)

[@yulinliu850]

Excellent! Thanks Leila.

[@LeilaGharani]

Glad you like the video. You're very welcome Yulin.

[@nostromo9081]

Beautiful and full of Excel wisdom :) My kind of girl.

[@1877Pegasus]

I love the three tips. All new for me

[@LeilaGharani]

Fantastic!

[@AnbarasuAnnamalai]

GOOD. I make visit to your channel almost daily to get new tips. Thank you.

[@LeilaGharani]

That's great! I'm glad the tutorials are helpful for you.

[@sandip_bettereveryday]

All three tips were known to me, but still it was a great fun to revisit. One tip I want to add is the following - If we want to move a chart by selecting and then pressing keyboard's arrow keys, it doesn't work. But if we press control and then select the chart and then press the arrow key, it works. (I'm completely depending on my memory here, as am not in front of my PC)

[@LeilaGharani]

Thank you Sandip! Yes that' a great tip too. Microsoft has included this in Excel 2016, 365 subscription. You no longer need to hold down the control key. Just click the chart and move with the arrow keys. For older versions though your memory is right. The control key is needed. Many thanks for sharing.

[@rezoanbangladesh5854]

Good job, Allah Bless you.

[@amitkalra8774]

Rocked again

[@KumarAnalytic]

Leila you've wonderful knowledge

[@Dev_Bartwal]

Very Useful...Thanks LG💞💞

[@LeilaGharani]

I'm glad you find these useful. Thank you for your support Dev :)

[@arnaudble8414]

Thk U very much, i knew just one of them

[@kironmona]

Excellent Tips. Worth watching.

[@LeilaGharani]

Thank you! Glad you like the tips.

[@carmenzal7214]

You are awesome. Thank you for your knowledge.

[@LeilaGharani]

You are very welcome

[@sanjitbasu615]

Thanks for this video

[@salehmohammad5170]

Awesome Leila

[@VSP4591]

Very clever. Thank you.

[@LeilaGharani]

Glad you like it!

[@user-eq7dk2lk2d]

thank you sweet queen

[@tahirhanif9669]

Brilliant thank you Leila

[@LeilaGharani]

You’re very welcome Tahir

[@arungupta4200]

These all 3 new for me thanks for these updates

[@LeilaGharani]

Glad you like them!

[@kishangzp]

excellent ... really useful tips. I was making it more complicated to do the same thing... thank you!

[@LeilaGharani]

Great to hear!

[@dianicawat350]

Very informative

[@carolynnewman612]

very helpful

[@namitagulavani6462]

Very useful tips for data represention will definitely apply over it.

[@LeilaGharani]

Glad it was helpful!

[@muthukannanshanmuganathan9107]

Cool stuff, rocked ususal:)

[@sunil7889]

excellent!

[@yongkysiaw6597]

Thank you so much for the first tip 👌

[@LeilaGharani]

My pleasure 😊

[@JaagiiBatochir]

new 3 out of 3. thanks

[@LeilaGharani]

Glad the video was useful :)

[@soumensingh6759]

Nice one ....

[@mgomaa9001]

Thanks

[@dbookmarker9524]

Love!

[@timbash7034]

New stuff, thank you so much for your knowledge and teachable spirit.

[@LeilaGharani]

You're very welcome Tim. Glad you found some (hopefully useful) new stuff :)

[@timbash7034]

Miss Leila, I have been using excel for quite sometime, but have learned by baptism by fire. I am impressed with the amount of knowledge and abilities that you share while working with this program. Because of the self training that I have done I have missed a lot of the termanology the you use and the different steps that scaffold you through excel. I would like to be much more knowledgeable in this program, could you please recommend a starting point so I might refresh and learn more. I am humbled to start at the beginning if need be. Thanks in advance for your help Tim

[@LeilaGharani]

Hi Tim - As you've used Excel for some time, I'd recommend an Excel Advanced training - something that fills in the gaps. I have a top 10 tips and 10 formulas training that takes you through tips that you might have missed. The link to the course is in the description of the video. If you'd like to learn from the beginning - Mike from ExcelIsFun KZbin channel has a great Excel basics playlist. Have fun learning :)

[@agarrett4693]

All new to me. Great!!

[@RehanShaikh-ip9hh]

Good one

[@zeratech3997]

Thanks for the tips......U r always simple

[@LeilaGharani]

You're welcome Zera :)

[@erumjawed966]

Thank you, didn't know them :)

[@adrianodossantosfernandes1236]

Leila I do really like your videos! Congrats

[@LeilaGharani]

Thank you so much!

[@weblady14]

1 & 2 were new to me, #3 I already knew from one of your former courses :)

[@LeilaGharani]

Great :)

Liked, Shared, subscribed and commented excellent video! 🙂🙂

[@LeilaGharani]

Thank you Gerardo for the like, share, subscribe and comment :) Really appreciate it. You have a great Excel channel as well. Do you do English videos as well?