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
Пікірлер: 259
Grab the file I used in the video from here 👉 pages.xelplus.com/chart-tips-file
Thanks for the charting tip fun, Teammate!
@LeilaGharani
6 жыл бұрын
You're very welcome Mike :)
@koengsinghz
6 жыл бұрын
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!
Perfect tips, thanks Leila.
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. :)
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
3 жыл бұрын
Glad you enjoyed it!
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.
Thanks for these tips. I do a lot of charts for many years and had these problems, solved from now on
Thank you very much Leila. Your sessions are really trustworthy and I hope, I will expect many more from you. Thanks again😊
@LeilaGharani
6 жыл бұрын
You're very welcome Sandeep. Will do my best to keep it up :) Thank you for your support.
Enjoyed it. All new to me. Thank you.
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
6 жыл бұрын
I’m really happy to hear you find the tutorials useful. Thank you for your support of my courses.
Very useful, thank You
Very new. I love your class, Professor. Take care.
Brilliant. More chart tips, please!
Simpele but super useful tips Leila! I did’nt know any of these three...
Thx for your smooth course.
Thanks again. Wonderful.
Excellant trick.......always rocked thx for sharing
Great tips 👌
Thanks for the tips. They were all new to me.
Brilliant, Leila - thank you for sharing!
@LeilaGharani
6 жыл бұрын
You're very welcome Gino.
Thanx for sharing such great tips
Love is how I describe Excel, Leila and her videos. Your videos make me look like a star in the workplace. Thank you.
@LeilaGharani
6 жыл бұрын
I love that! Thank you Jed for the nice comment. Using the stuff learnt is actually the difficult part - well done!
Beautiful tutorial
All of them are new and super useful. 👍
Thanks for sharing. All new to me
Wow! Awesome tips! Two of them I had not heard of before today! Thank you, Leila!
@LeilaGharani
6 жыл бұрын
You're very welcome Sandy! Glad you find the tips useful :)
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
Excellent Leila. Hidden columns settings are new to me. Good to add additional tips from the other 2 tips to my library
@LeilaGharani
6 жыл бұрын
I'm happy you found some new tips. Yes - the hidden columns one is a bit tricky to find.....
All of the three are new to me, thanks a lot
All 3 were new to me and very useful too. Thank you, Leila.
@LeilaGharani
4 жыл бұрын
My pleasure Diana.
Thanks for these tips Leila, that's awesome
@LeilaGharani
3 жыл бұрын
You're so welcome!
The last tip was new. Thanks!!!
Excellent Tips. Worth watching.
@LeilaGharani
6 жыл бұрын
Thank you! Glad you like the tips.
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
6 жыл бұрын
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!
These were all new to me! Thank you so much !
@LeilaGharani
4 жыл бұрын
So glad!
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
6 жыл бұрын
You're very welcome Farooq. I use that one a lot too.
Leila you've wonderful knowledge
Hi Leila, all three tips were new to me. Thanks for sharing.
@LeilaGharani
6 жыл бұрын
You're very welcome. Thank you for the support.
Very useful, many thanks Leila!
@LeilaGharani
6 жыл бұрын
You're very welcome.
Excellent..
Thanks a ton
Excellent. Leila, thanks for sharing.
@LeilaGharani
6 жыл бұрын
You're very welcome :)
Thank U so muchhhhh!!!! Vital!!!
Thanks for this video
Thk U very much, i knew just one of them
all three new to me.....that was awesome....thanks!!
@LeilaGharani
3 жыл бұрын
Glad you enjoyed it!
Very informative
Thanks for the pro tips. Tip 1 and 3 were new for me.
@LeilaGharani
6 жыл бұрын
You're welcome. Glad you found something new here :)
Tip 3 was new to me, thanks
This is new for me... thank u
Thanks for sharing the tips!
@LeilaGharani
6 жыл бұрын
You're very welcome Doug :)
Yes this new to me, and really very helpful. Thank you so much for the video
@LeilaGharani
3 жыл бұрын
You are so welcome!
very helpful
Thanks! Didn’t know these ones. Always looking for more to learn.
@LeilaGharani
4 жыл бұрын
Hope these tips will come in handy for you.
Very clever. Thank you.
@LeilaGharani
4 жыл бұрын
Glad you like it!
excellent ... really useful tips. I was making it more complicated to do the same thing... thank you!
@LeilaGharani
4 жыл бұрын
Great to hear!
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!
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
6 жыл бұрын
You're very welcome. Agree - better late than never :)
great the one new to me is the hidden rows or column thank you so much Ms. Leila
@LeilaGharani
6 жыл бұрын
Glad you found something new Ismail :)
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 👍
Excellent tips! I did not know how to do any of these 3 before watching the video. Very helpful! Thank you!!!
@LeilaGharani
6 жыл бұрын
Glad you find these helpful :) Thank you for your feedback.
Thank you, didn't know them :)
Cool stuff, rocked ususal:)
Excellent! Thanks Leila.
@LeilaGharani
6 жыл бұрын
Glad you like the video. You're very welcome Yulin.
You are awesome. Thank you for your knowledge.
@LeilaGharani
4 жыл бұрын
You are very welcome
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
4 жыл бұрын
Great to hear!
Tips 2 and 3 were very helpful, Thanks !
@LeilaGharani
5 жыл бұрын
Glad the tutorial is helpful.
Awesome. Especially the first tip able to resolve most of my charts issue when data needs to be hidden. Thank you.
@LeilaGharani
6 жыл бұрын
That's great. I'm happy to hear you find the tips useful.
Thanks for the tips. This is so simply effective.
@LeilaGharani
5 жыл бұрын
You're very welcome. Glad you like it.
Brilliant thank you Leila
@LeilaGharani
6 жыл бұрын
You’re very welcome Tahir
You are amazing, the three tips were new to me. Thank you!!
@LeilaGharani
4 жыл бұрын
My pleasure. Glad you found something new.
excellent!
Very Useful...Thanks LG💞💞
@LeilaGharani
6 жыл бұрын
I'm glad you find these useful. Thank you for your support Dev :)
Thanks for the tips......U r always simple
@LeilaGharani
6 жыл бұрын
You're welcome Zera :)
Very useful tips for data represention will definitely apply over it.
@LeilaGharani
3 жыл бұрын
Glad it was helpful!
thanks a lot for everything. you enrich our knowledge by delivering such awesome videos. thank you very much
@LeilaGharani
6 жыл бұрын
It's my pleasure! Thank you for your support of my tutorials.
Thank you so much for the first tip 👌
@LeilaGharani
4 жыл бұрын
My pleasure 😊
These all 3 new for me thanks for these updates
@LeilaGharani
4 жыл бұрын
Glad you like them!
Nice one ....
Good one
Awesome Leila
I love the three tips. All new for me
@LeilaGharani
4 жыл бұрын
Fantastic!
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
3 жыл бұрын
Thanks for your feedback, John!
Thanks
Leila I do really like your videos! Congrats
@LeilaGharani
2 жыл бұрын
Thank you so much!
The last trick was new to me I always just grouped to objects as one. Always clear and accessible videos.👌
@LeilaGharani
2 жыл бұрын
Cool, thanks!
new 3 out of 3. thanks
@LeilaGharani
4 жыл бұрын
Glad the video was useful :)
Love!
You are a great excel teacher ma'am. Thank you very much
@LeilaGharani
4 жыл бұрын
Thank you! 😃
Your tutorials are just amazing I must say
@LeilaGharani
6 жыл бұрын
I'm glad you like them Alex :)
Thanks Leila Very Helpful :)
@LeilaGharani
6 жыл бұрын
You're very welcome John :)
GOOD. I make visit to your channel almost daily to get new tips. Thank you.
@LeilaGharani
4 жыл бұрын
That's great! I'm glad the tutorials are helpful for you.
Rocked again
Adding a shape into a chart is very cool, Thank you.
@LeilaGharani
6 жыл бұрын
You're welcome Chaminda. I use that one a lot actually..
thank you sweet queen
Awesome
Thank you Leila, great fun tips :-)
@LeilaGharani
6 жыл бұрын
You're very welcome Tamir :)
Good job, Allah Bless you.
Beautiful and full of Excel wisdom :) My kind of girl.
New stuff, thank you so much for your knowledge and teachable spirit.
@LeilaGharani
6 жыл бұрын
You're very welcome Tim. Glad you found some (hopefully useful) new stuff :)
@timbash7034
6 жыл бұрын
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
6 жыл бұрын
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 KZread channel has a great Excel basics playlist. Have fun learning :)
@agarrett4693
4 жыл бұрын
All new to me. Great!!