3 REALLY Useful Excel Chart Tips You May Have Missed

Показать описание

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.

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.

★ Links to related videos: ★

🚩Let’s connect on social:

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

Рекомендации по теме

Комментарии

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 👍

ubaidyaseencubaidyaseenc

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.

johnwait

This is very usual, I did miss all 3! Thanks Leila.

kerrywan

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.

anujain

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.

natalievo

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

PK-ilum

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

peterbriggs

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

AussieDropBear

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

dianacampbell

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)

sandip_bettereveryday

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

PaulVass

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

kishangzp

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.

TylehurstXL