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.
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.
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!
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.
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. 😊
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
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)
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.
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.
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. :)
Glad you find them useful. It took me some time to find the un-snapping one.... when we were trying to figure out why the ALT key wasn't working for one person at a training.
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!
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
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 RUclips channel has a great Excel basics playlist. Have fun learning :)
Hey Leila your too good as always... can you do a video on graphs standard visualisation like what presets, shadows or what all needed to show a graph very neat and eye catching... thanks for your help...
Hey Leila ! excellent trips and as always you rocks with such a simple but very essential and handy techniques, keep sharing One request, if you can let me know how to create error bar in excel 2010 ?
Glad you like the tips! You need to activate error bars from the ribbon tab - not sure which tab they are in since I don't have Excel 2010 with me - but if I'm not mistaken, I think it's called the layout tab. Error bar option is sitting on the right hand-side of the tab.
Hi Leila, I need to do an "animated" chart, i.e. a line chart from historical series that shows year by year but in an automatically way while a year counter shows the year value. What would you use in this case? Is this a movie or is there some Excel tip to do it? Thanks!!
The first tip solved one of my chronic helper column problem. I used helpers in few charts and later want to hide helpers. But hiding column make it disappear from chart as shown in video. I used to change the font color of helper cells to white :) Feeling stupid now!
Grab the file I used in the video from here 👉 pages.xelplus.com/chart-tips-file
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 👍
This is very usual, I did miss all 3! Thanks Leila.
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.
Thanks for your feedback, John!
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.
Glad you enjoyed it!
Love is how I describe Excel, Leila and her videos. Your videos make me look like a star in the workplace. Thank you.
I love that! Thank you Jed for the nice comment. Using the stuff learnt is actually the difficult part - well done!
All 3 were new to me and very useful too. Thank you, Leila.
My pleasure Diana.
Thanks for these tips. I do a lot of charts for many years and had these problems, solved from now on
Thanks for the charting tip fun, Teammate!
You're very welcome Mike :)
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!
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.
You're very welcome Farooq. I use that one a lot too.
Hi Leila, all three tips were new to me. Thanks for sharing.
You're very welcome. Thank you for the support.
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.
Great to hear!
Excellent Leila. Hidden columns settings are new to me. Good to add additional tips from the other 2 tips to my library
I'm happy you found some new tips. Yes - the hidden columns one is a bit tricky to find.....
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. 😊
You're very welcome. Agree - better late than never :)
Very new. I love your class, Professor. Take care.
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!
I’m really happy to hear you find the tutorials useful. Thank you for your support of my courses.
The last trick was new to me I always just grouped to objects as one. Always clear and accessible videos.👌
Cool, thanks!
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
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)
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.
These were all new to me! Thank you so much !
So glad!
excellent ... really useful tips. I was making it more complicated to do the same thing... thank you!
Great to hear!
Excellent tips! I did not know how to do any of these 3 before watching the video. Very helpful! Thank you!!!
Glad you find these helpful :) Thank you for your feedback.
GOOD. I make visit to your channel almost daily to get new tips. Thank you.
That's great! I'm glad the tutorials are helpful for you.
Simpele but super useful tips Leila! I did’nt know any of these three...
Brilliant. More chart tips, please!
The last tip was new. Thanks!!!
Excellent Tips. Worth watching.
Thank you! Glad you like the tips.
Thanks for these tips Leila, that's awesome
You're so welcome!
Yes this new to me, and really very helpful. Thank you so much for the video
You are so welcome!
Very useful, many thanks Leila!
You're very welcome.
great the one new to me is the hidden rows or column thank you so much Ms. Leila
Glad you found something new Ismail :)
All of them are new and super useful. 👍
You are a great excel teacher ma'am. Thank you very much
Thank you! 😃
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.
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!
Thanks for the tips. They were all new to me.
Awesome. Especially the first tip able to resolve most of my charts issue when data needs to be hidden. Thank you.
That's great. I'm happy to hear you find the tips useful.
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.
Very useful tips for data represention will definitely apply over it.
Glad it was helpful!
Thanks, yes it really did help. I want to lean word from basic to advance could you pls help with some recommend videos and links Thanks.
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. :)
Hi Leila, tips are good. I am familiar with holding down ALT to snap to grid but did not know on un-snapping to grid. Thanks.
Glad you find them useful. It took me some time to find the un-snapping one.... when we were trying to figure out why the ALT key wasn't working for one person at a training.
Wow! Awesome tips! Two of them I had not heard of before today! Thank you, Leila!
You're very welcome Sandy! Glad you find the tips useful :)
Leila I do really like your videos! Congrats
Thank you so much!
Thanks! Didn’t know these ones. Always looking for more to learn.
Hope these tips will come in handy for you.
Adding a shape into a chart is very cool, Thank you.
You're welcome Chaminda. I use that one a lot actually..
Thanks for the tips......U r always simple
You're welcome Zera :)
Enjoyed it. All new to me. Thank you.
all three new to me.....that was awesome....thanks!!
Glad you enjoyed it!
Tip 3 is so handy. I use that for adding dynamic text like xx% over budget.
I use this one a lot as well...
thanks a lot for everything. you enrich our knowledge by delivering such awesome videos. thank you very much
It's my pleasure! Thank you for your support of my tutorials.
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!
I love the three tips. All new for me
Fantastic!
You are awesome, I learn alot from your videos and I've been using Excel for years! what country are you from? What country do you live now?
I'm glad you're finding new stuff here that can help with your work. I'm from Iran - live in Austria.
You are amazing, the three tips were new to me. Thank you!!
My pleasure. Glad you found something new.
Thanks for sharing. All new to me
You are awesome. Thank you for your knowledge.
You are very welcome
Your tutorials are just amazing I must say
I'm glad you like them Alex :)
Brilliant, Leila - thank you for sharing!
You're very welcome Gino.
Thank you very much Leila. Your sessions are really trustworthy and I hope, I will expect many more from you. Thanks again😊
You're very welcome Sandeep. Will do my best to keep it up :) Thank you for your support.
Tips 2 and 3 were very helpful, Thanks !
Glad the tutorial is helpful.
Beautiful tutorial
Excellent. Leila, thanks for sharing.
You're very welcome :)
All of the three are new to me, thanks a lot
Very useful, thank You
Thank you so much for the first tip 👌
My pleasure 😊
Thanks for the pro tips. Tip 1 and 3 were new for me.
You're welcome. Glad you found something new here :)
Great tips 👌
Tip 3 was new to me, thanks
Excellant trick.......always rocked thx for sharing
These all 3 new for me thanks for these updates
Glad you like them!
New stuff, thank you so much for your knowledge and teachable spirit.
You're very welcome Tim. Glad you found some (hopefully useful) new stuff :)
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
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 RUclips channel has a great Excel basics playlist. Have fun learning :)
All new to me. Great!!
Very clever. Thank you.
Glad you like it!
The third tip will come in very handy. I did know one and two already but I think that's because of one of your earlier videos (for two anyway)
:) Glad to hear that. Yes - I use the 3rd one quite often actually....
Hey Leila your too good as always... can you do a video on graphs standard visualisation like what presets, shadows or what all needed to show a graph very neat and eye catching... thanks for your help...
Glad you like the video. Regarding your request, I have something similar here: ruclips.net/video/CtwKTwTFL64/видео.html. Hope this helps.
1st one is new to me .. thanks 🙏
My pleasure :)
Hey Leila ! excellent trips and as always you rocks with such a simple but very essential and handy techniques, keep sharing
One request, if you can let me know how to create error bar in excel 2010 ?
Glad you like the tips! You need to activate error bars from the ribbon tab - not sure which tab they are in since I don't have Excel 2010 with me - but if I'm not mistaken, I think it's called the layout tab. Error bar option is sitting on the right hand-side of the tab.
Excellent! Thanks Leila.
Glad you like the video. You're very welcome Yulin.
Thanks for the tips. This is so simply effective.
You're very welcome. Glad you like it.
Brilliant thank you Leila
You’re very welcome Tahir
Hi Leila, I need to do an "animated" chart, i.e. a line chart from historical series that shows year by year but in an automatically way while a year counter shows the year value. What would you use in this case? Is this a movie or is there some Excel tip to do it? Thanks!!
I made it!!!! :)
Leila you've wonderful knowledge
thanks Laila , can you provide VBA session plz
Thank you, didn't know them :)
Thanks for sharing the tips!
You're very welcome Doug :)
Thk U very much, i knew just one of them
Very informative
new 3 out of 3. thanks
Glad the video was useful :)
1 & 2 were new to me, #3 I already knew from one of your former courses :)
Great :)
The first tip solved one of my chronic helper column problem. I used helpers in few charts and later want to hide helpers. But hiding column make it disappear from chart as shown in video. I used to change the font color of helper cells to white :) Feeling stupid now!
Glad the video is helpful to get rid of your helper column Aleem :)
Thank you Leila, great fun tips :-)
You're very welcome Tamir :)
Thank U so muchhhhh!!!! Vital!!!
Is there any way to add different color to legend/ axis text (assuming there are multiple legends or axis)?
For the text inside the shape, could we use formula to combine the text?
Thanx for sharing such great tips
Very Useful...Thanks LG💞💞
I'm glad you find these useful. Thank you for your support Dev :)
Awesome Leila
very helpful
Thx for your smooth course.
Excellent..
Thank you, Three are new to me😱
You're very welcome Suresh :)