How to Make Bar Chart in Excel

Рет қаралды 192,901

Күн бұрын

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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!AmxrofZZlZ-wha8QA...
- 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.com/newsletter/
🔽 CONNECT WITH ME
- Official website: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- 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.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZfaq
kzfaq.info?...
🙌 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

Пікірлер: 56

@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: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📊 Learn Excel in just 15 minutes: kzfaq.info/get/bejne/gs2Ird2mm57OZ4E.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

@Lilienin 6 ай бұрын

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

@mikea8225 8 ай бұрын

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

@cambelio 9 ай бұрын

Perfect exactly what I was looking for.

@Modise__ZA 4 ай бұрын

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

@junec216 5 ай бұрын

Thank you! I needed this.

@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.😂😂

@pamelanelson459 6 ай бұрын

Thank you young man.

@ladonnacoleman9674 9 ай бұрын

Thanks Kevin. I like the hair cut.

@gayanwithanage6729 9 ай бұрын

Thank you ❤

@xaraxaritou4789 9 ай бұрын

Thank you for sharing!!

@KevinStratvert 9 ай бұрын

Thanks for watching!

@alonaisrael 7 ай бұрын

Thank you 👍

@Uptight_2 9 ай бұрын

Thank you for the information.

@KevinStratvert 9 ай бұрын

Any time!

@sohaibyahia9443 3 ай бұрын

thank you so much

@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!

@Buharialtinee 9 ай бұрын

Thanks for sharing

@KevinStratvert 9 ай бұрын

You bet!

@shivu143as 8 ай бұрын

Easy understanding.. please make videos for Dash board making

@AutoCAD_Troubleshooting 8 ай бұрын

Always good❤

@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?

@AnnoyedBamboo-if6zt Ай бұрын

How about to add more bars on chart

@biplabdasgupta 5 ай бұрын

@kevin how to create Ribbon Chart in MS office? Is there any tutorial?

@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

@abdulrafey1914 7 ай бұрын

Bravo

@MoonShine-bs6cl 3 ай бұрын

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

@tannushree5542 8 ай бұрын

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??

@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?

@kameshsubramanian2553 8 ай бұрын

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 8 ай бұрын

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

@kameshsubramanian2553 8 ай бұрын

@@KevinStratvert thanks Kevin

@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?

@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.

@dranreb330 8 ай бұрын

What to do without pressing Alt+F1?

@cyberswarup 8 ай бұрын

There should have been simple option in header/footer, like "start page number from" from a specific page.

@thandokazintenetya508 4 ай бұрын

This is awesome,really enjoying Excell now😊Thanks you

@devinkethmin4064 9 ай бұрын

Just like that I can show the revenues easily in exel

@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