🥷 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html 📊 Learn Excel in just 15 minutes: ua-cam.com/video/LgXzzu68j7M/v-deo.html
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 🎉
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?
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.
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
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?
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?
🎉🎉🎉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 😢
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.
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
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
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??
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?
🥷 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: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
📊 Learn Excel in just 15 minutes: ua-cam.com/video/LgXzzu68j7M/v-deo.html
Thank you Kevin!!
I've been waiting in the middle of the night just in case he released a video, finally it paid off.
😂👍
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 🎉
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
Just came across your channel and you really make excel so easy to understand 👌
Please make this type of video more frequently it is very informative
More to come! Let me know if there are any topics that interest you.
Thanks Kevin. I like the hair cut.
Perfect exactly what I was looking for.
Well done kevin
This will help us to show revenue of a business
Love it!
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?
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.😂😂
Thanks for sharing
You bet!
thank you so very much! i needed that video and you way of explaining was top tier. ❤
Thank you for the information.
Any time!
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.
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
Thank you young man.
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?
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?
Thank you for sharing!!
Thanks for watching!
Thank you! I needed this.
Hey awesome video as always! The editing and research done to provide this video is top notch!
Easy understanding.. please make videos for Dash board making
🎉🎉🎉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 😢
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.
Thank you ❤
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
How about to add more bars on chart
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
idunno what im doing at all. ive never used excel ever
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??
This is awesome,really enjoying Excell now😊Thanks you
@kevin how to create Ribbon Chart in MS office? Is there any tutorial?
thank you so much
Always good❤
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?
Check out 9:09 in the video for steps that show how to adjust the gap width.
@@KevinStratvert thanks Kevin
There should have been simple option in header/footer, like "start page number from" from a specific page.
Just like that I can show the revenues easily in exel
What to do without pressing Alt+F1?
Kevin, can you create a video on how to create live timezones in excel?
Tell me more… do you just want a specific time in a cell for a specified time zone?
Bravo
Nice video first comment
My data isn’t coming in correct.
First
Pin me
Superb
Thanks for sharing
You bet!
Thank you
👍