No video :(

How to Make Bar Chart in Excel

Подписаться 3,1 млн

Просмотров 200 тыс.

50% 1

In this video, you will learn how to create different types of charts in Microsoft Excel, such as column charts, bar charts, stacked column charts, and multiple columns charts. You will also learn how to insert a chart using the insert ribbon or the shortcut key Alt + F1. You will see how to add elements to your chart, such as titles, labels, legends, and gridlines. You will also learn how to format your chart, such as changing the colors, fonts, and styles. By the end of this video, you will be able to create professional-looking charts in Excel that can help you visualize and analyze your data.
📚 RESOURCES
- Workbook to follow along: 1drv.ms/x/s!Am...
- Alt + F1 to quickly insert a column chart
⌚ TIMESTAMPS
00:00 Introduction
00:21 Insert column chart
01:39 Change to bar chart
02:31 Bar chart vs. column chart
03:25 Shortcut to insert column chart
03:50 Add chart elements
04:50 Quick layouts
05:12 Change colors and styles
05:27 Add dynamic title
06:20 Multiple columns chart
07:53 Change colors
08:42 Adjust bar thickness and gap size
09:32 Stacked column chart
10:28 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert...
🔽 CONNECT WITH ME
- Official website: www.kevinstratv...
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinSt...
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert...
🙏 REQUEST VIDEOS
forms.gle/BDrT...
🔔 SUBSCRIBE ON RU-vid
www.youtube.co...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #excel #excelcharts

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

18 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

Комментарии : 58

@KevinStratvert 9 месяцев назад

🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com ⏭ Watch more free Excel tutorial videos: ru-vid.com/group/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 Learn Excel in just 15 minutes: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LgXzzu68j7M.html

@xaraxaritou4789 9 месяцев назад

Thank you Kevin!!

@1776huckleberry 9 месяцев назад

I've been waiting in the middle of the night just in case he released a video, finally it paid off.

@markus_aurelius_888 9 месяцев назад

😂👍

@SeanAbbey 9 месяцев назад

Thanks Kevin, very handy for my work. The ability To make complex issues, simple is a sign of an excellent teacher. Thanks again Kevin, much appreciate all the help in these crazy times, we are living in 🎉

@matioesperante7518 9 месяцев назад

I'm so grateful for this video - most videos are about tables and statistics and its nice to consider other ways to show the data

@Modise__ZA 5 месяцев назад

Just came across your channel and you really make excel so easy to understand 👌

@ladonnacoleman9674 9 месяцев назад

Thanks Kevin. I like the hair cut.

@cambelio 9 месяцев назад

Perfect exactly what I was looking for.

@Buharialtinee 9 месяцев назад

Thanks for sharing

@KevinStratvert 9 месяцев назад

You bet!

@Lilienin 6 месяцев назад

thank you so very much! i needed that video and you way of explaining was top tier. ❤

@Uptight_2 9 месяцев назад

Thank you for the information.

@KevinStratvert 9 месяцев назад

Any time!

@angelique3605 7 месяцев назад

No doubt your lessons are superb and quite understandable. Well done. I must also say that I like the music at the end of the lessons.😂😂

@junec216 6 месяцев назад

Thank you! I needed this.

@xaraxaritou4789 9 месяцев назад

Thank you for sharing!!

@KevinStratvert 9 месяцев назад

Thanks for watching!

@Trio_Lecture 9 месяцев назад

Please make this type of video more frequently it is very informative

@KevinStratvert 9 месяцев назад

More to come! Let me know if there are any topics that interest you.

@devinkethmin4064 9 месяцев назад

Well done kevin This will help us to show revenue of a business

@KevinStratvert 9 месяцев назад

Love it!

@pamelanelson459 7 месяцев назад

Thank you young man.

@mikea8225 9 месяцев назад

Hey awesome video as always! The editing and research done to provide this video is top notch!

@shivu143as 9 месяцев назад

Easy understanding.. please make videos for Dash board making

@gayanwithanage6729 9 месяцев назад

Thank you ❤

@alonaisrael 7 месяцев назад

Thank you 👍

@sohaibyahia9443 3 месяца назад

thank you so much

@what_she_said_club 6 дней назад

How would you make a bar a stacked bar if your graph has 3 sets of data in it; two sets of data is using a line and the third a column bar chart? so one bar would show how many people left in june and from what 2 teams?

@InfoElevateLife 2 месяца назад

I'm trying to create a horizontal bar chart from vertical data. I want the bar chart to sit next to the data (without any labels, axis, lines etc - just bars and data), but the data on the bar chart isn't reflecting the data its sitting next to, its picking up the data from the bottom of the vertical data list first. Any idea how I can flip it so data and bar match?

@MoonShine-bs6cl 4 месяца назад

Hi your videos are amazing but i have one urgent requirement please can you help me at the earliest by making video how to create normal bar and clustered stacked bar chart in excel for 2 years, as normal bar will be totL sales for 2023 and clustered stacked bar should have both sales values and %on sales month wise for 12 months, it would b a great help... Thanks in advance

@AutoCAD_Troubleshooting 9 месяцев назад

Always good❤

@QueenBee-ig2tp 2 месяца назад

Hi there, I am a senior and have got to produce a chart for the Government. I need to be able to put in an amount per/mth then in the next column have to take 48.9% and then give the total amount remaining in the next column. I didnt have Excel in school so do you have a video of something like this .? or I am dreaming and have to get an accountant?

@Casey-One 2 дня назад

Would anyone know why my Alt + F1 is not working? I am pressing F1 and Alt at the same time but it would Mutes as F1 is the mute button. I am not pressing the + sign, and I am on an acer laptop.

@othmanaljbory3649 9 месяцев назад

🎉🎉🎉thank you There is a problem. If you have a request that contains large numbers, the diagram will become confusing and not clear. What should I do if I have large numbers? 😢I have three columns 😢

@KevinStratvert 9 месяцев назад

A few options: - You can use a simple formula to divide the number by a thousand or a million, and then apply the number format you want. - You can use the custom number format option to display the number with comma separators or with K for thousands or M for millions. This will not change the actual value of the cell, only how it is displayed.

@AnnoyedBamboo-if6zt 2 месяца назад

How about to add more bars on chart

@thandokazintenetya508 4 месяца назад

This is awesome,really enjoying Excell now😊Thanks you

@tannushree5542 9 месяцев назад

Hey, i have a question, i tried to give my exam for ms excel certification but it says that the exam has espired for those who want to give it in English, what shd i do??

@brydenkim 9 месяцев назад

Kevin, can you create a video on how to create live timezones in excel?

@KevinStratvert 9 месяцев назад

Tell me more… do you just want a specific time in a cell for a specified time zone?

@kameshsubramanian2553 9 месяцев назад

Hi Kevin. Good video. When I do the bar chart, the gap in the horizontal axis is big (between 100 to 200) leading to lots more of lines. Is there any way this can be fixed?

@KevinStratvert 9 месяцев назад

Check out 9:09 in the video for steps that show how to adjust the gap width.

@kameshsubramanian2553 9 месяцев назад

@@KevinStratvert thanks Kevin

@tweety9473 6 месяцев назад

Hey kevin hows it going can you help me pls how to make a expiration chart bass on a month with diferent parameters lets i would like to make on 1/1/24 with 30,45,75,90,120,180 days also would be great if we can add a julian date thanks

@cstpa1 2 месяца назад

what are the reasons chart element might be greyed out? is it because i have no information ? i'm following my school's tutorial and it said here's how to insert chart. i have no numbers or anything. i just inserted a chart. its a big white square. and then the tutorial is immediately like here's chart elements, but i can't click on it. now i'm here trying to figure out why

@cstpa1 2 месяца назад

idunno what im doing at all. ive never used excel ever