Тёмный

Excel Charts & Graphs - Pie, Bar, Waterfall, Thermometer graph, Column & Line Chart 

Excel Superstar
Подписаться 385 тыс.
Просмотров 50 тыс.
50% 1

Imagine this! You're sitting in front of your computer, looking at a colossal spreadsheet. There are hundreds of rows and columns, and you're trying to make sense of it all. It's time to let Excel do the work for you. In this tutorial, I'll show you how to create some really cool charts, with data from a fictitious company's budget.
Check out our 24 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
00:00 Introduction to Excel Charts Advanced
00:57 How to create a Chart in Excel
02:20 How to use Format Data Series Function in Excel
03:08 How to Reverse the Categories in Excel Chart
04:17 How to use Data Label in Excel Chart
08:11 How to Add borderline or dash line in Excel Chart
08:56 How to Change Y-axis Values in Excel Chart
09:41 How to Remove Gridlines in Excel Charts
10:16 Dynamic Title Format in Excel Chart
12:38 How to use Pie Chart in Excel
15:51 How to use Treemap Chart in Excel
16:44 How to Add Labels in Treemap Chart
17:49 Treemap for category and sub-category in Excel
19:31 Negative Points of Treemap in Excel
21:04 Why is a two-axis chart needed?
22:19 How to use a two-axis chart in Excel
23:41 How to change outline in Excel Chart
24:16 How to use Marker Function in Excel
26:14 How to create a Thermometer Chart? - two styles in Excel
29:31 How to Data Sort in Excel
30:13 Thermometer Chart example no. 2
31:14 How to use Gap Width Function in Excel
31:58 How to change the axis in Excel Thermometer Chart
35:17 How to Insert Average line in Excel Chart
36:36 How to use Data Source Pannel in Excel
37:24 How to change Column Chart to Line Chart in Excel
38:34 How to create Automatic Negative Color in Excel Chart
39:19 Excel Horizontal Data Sort Hidden Trick
40:06 How to Change Color if negative in Excel Chart
41:16 How to Change Label in Excel Chart
42:29 How to use Waterfall Chart in Excel
48:54 Configure using "Select Data" in Excel Chart
52:05 How to use Stacked Column Chart in Excel
53:02 How to use Switch Row/Column Stacked Column Chart in Excel
53:43 How to change a Category name in Stacked Column Chart in Excel
54:35 100% Stacked Bar in Excel
58:00 How to Change Color in Excel 100% Stacked Bar
59:05 Example of 100% Stacked Bar in Excel
01:01:58 Rebase start value as 100 ('Normalise' the variables)
01:04:08 How to use Indexing in Excel
01:05:29 How to Insert Line Chart in Excel
15 Excel CHARTS recommended by Rishabh | Excel in Hindi
#excelcharts #businessdashboard #excelinhindi
To watch more videos visit: www.excelsuperstar.org/​​​​​​​​​
To Buy an Excel Course visit: www.courses.excelsuperstar.org
Like us on Facebook: / excelsuperstar​​
Subscribe to the Channel: / excelsuperstar

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

 

14 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 135   
@ananthakrishnanramakrishna9930
@ananthakrishnanramakrishna9930 Месяц назад
Well explained with practical examples....creates a good base to explore and learn more. Thank you.
@mahammadmansoor9614
@mahammadmansoor9614 Месяц назад
I had never seen such a clear explanation of charts, Thank you.
@1974manna
@1974manna Месяц назад
Your way of explaining and expressing things is just awesome, God bless you. Keep posting knowledge
@spanditaroy9973
@spanditaroy9973 Год назад
Excellent explanation thanks a ton
@entertainmenator1488
@entertainmenator1488 2 года назад
I work in finance as Investment Analyst and I found this tutorial very useful, many thanks
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Great to hear!
@syed599
@syed599 Год назад
Best video I have ever seen on chart
@jagdishagarwal4173
@jagdishagarwal4173 Год назад
superb!! liked explanation and detailing
@harshgandhi6154
@harshgandhi6154 2 года назад
Amazing video💯 Got to learn so many things🙏
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Glad to hear that!
@AmitGupta-bl2iu
@AmitGupta-bl2iu 2 года назад
India's best Teacher 🥳🥳
@jitanshukoli4230
@jitanshukoli4230 4 месяца назад
Really a excel superstar ever, Thankyou so much sir for this explanation.
@rajudamale2
@rajudamale2 22 дня назад
Awesome 👌🏻
@ddifferent21
@ddifferent21 8 месяцев назад
Finally found a good video to learn some basics, most video of ppt are useless in real use...
@Dhundkari10
@Dhundkari10 6 месяцев назад
Thanks for this video
@ravislath
@ravislath 2 года назад
Rishab - beautifully explained, itna simple , like really .. itnaaaa simple
@rishabhpugalia9281
@rishabhpugalia9281 2 года назад
I am glad to hear that the explanation was clear.
@sumanasaha1832
@sumanasaha1832 8 месяцев назад
Great.
@shahadatshawon9716
@shahadatshawon9716 Год назад
Superb.
@makeshn9813
@makeshn9813 2 года назад
Super Guru.
@hareshengserviceworks2287
@hareshengserviceworks2287 2 года назад
Thanks Rishabh, keep doing good work! God bless you.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks a ton
@creativeshardapugalia
@creativeshardapugalia 2 года назад
Very good ! Very well explained and presented . 👍👍👍
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thank You - RP
@kainaatkhan4443
@kainaatkhan4443 Год назад
Amazing
@salilpattanayak7726
@salilpattanayak7726 3 месяца назад
Great sir, thanks
@zameerhussain2266
@zameerhussain2266 2 года назад
Very informative easy to understand. thank you so much for this wonderful video.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Glad it was helpful!
@swapniljadhav5249
@swapniljadhav5249 2 года назад
Beautiful video.. Very much helpful
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Glad to hear that
@vuppulaashokkumar2115
@vuppulaashokkumar2115 5 месяцев назад
thankyou sir excellent
@rohitvautre3159
@rohitvautre3159 2 года назад
Very informative video. I got to learn too many things here. Thanks for making this.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Glad you enjoyed it!
@mandymoore4045
@mandymoore4045 2 года назад
You the best Mr excel
@sakshinarayanaswamy1273
@sakshinarayanaswamy1273 2 года назад
Excellent video crystal clear explanation. Was able to digest each and every word. God bless you awaiting for more videos
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thank you, I will
@user-xp8yw6fg8t
@user-xp8yw6fg8t 8 месяцев назад
Rishabhji sir, Thank Very Much & I am Grateful To you Explaining In Cool & In depth Knowledge Given To Me .I Am Life Long Long Forget You Sir , You Have Explained In such Way , I Never Seen In My Life . I Did My Engineering In Chemical , IN 1997. Sir I Don't Have Words To Express MY Feeling , GOOD Night Sir.
@ganeshugale3257
@ganeshugale3257 2 года назад
Thank You sir... Mind Blowing...Waterfall was Outstanding... I am big Fan of Your Training & Teaching since you came in Monsanto in 2016 Live session..
@rishabhpugalia9281
@rishabhpugalia9281 2 года назад
Wow, you remember - Thank You
@ganeshugale3257
@ganeshugale3257 2 года назад
@@rishabhpugalia9281 Yes Sir.. Still I am having your excel Handbook PDF & excel Practice Files In my Laptop.. Which helps me & my friends as well...
@amanojha5885
@amanojha5885 2 года назад
thank you sir, you are really nice.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks and welcome
@arpitaagrawal6812
@arpitaagrawal6812 11 месяцев назад
Very nice
@BKumar6677
@BKumar6677 2 года назад
Thank-you so much for this❤️
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Welcome 😊
@md.mobarakhosen6361
@md.mobarakhosen6361 2 года назад
Amazing tutorial.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thank you!
@ramdashwant2024
@ramdashwant2024 2 года назад
Great work, thank you
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thank you too!
@Vishalkumar-zg8uj
@Vishalkumar-zg8uj 2 года назад
I found this type video so many days but i don't geting, now i get it just because of you sir thanku so much for this video 🙏
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Glad to hear that
@abdulsalam935
@abdulsalam935 2 года назад
Sir, superb video with clear explanation. Hope you will release longer videos on each excel functions.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Sure I will
@BadalBabuBhattarai
@BadalBabuBhattarai 2 года назад
Wonderful!
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thank you! Cheers!
@sc15476
@sc15476 2 года назад
wonderfull video on charts
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Glad you like them!
@mamalik1088
@mamalik1088 2 года назад
Again nice knowledge u delivered
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks again
@mjaved701
@mjaved701 2 года назад
Salam to your efforts. Great video
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks for liking
@goyalmukeshkumar
@goyalmukeshkumar 2 года назад
Grate sir good valuable Video
@khalidmajeed2886
@khalidmajeed2886 2 года назад
to me it is really a great video. Sir i love your explanation...............................
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Keep watching
@6parim
@6parim 2 года назад
love you bhai
@RajniPal-vx4zq
@RajniPal-vx4zq 3 месяца назад
Explained very well
@DKumar-ww3rn
@DKumar-ww3rn 2 месяца назад
😮z
@rajvlogsparivar
@rajvlogsparivar 2 года назад
Excited...
@canirmalchoudhary8173
@canirmalchoudhary8173 2 года назад
It is awesome video on chart. I learnt so many things- rebase, waterfall, treemap. Thank you so much for bringing it. One requirement from my side, please make video on MS 365. I want to see you more in that version.
@rishabhpugalia9281
@rishabhpugalia9281 2 года назад
In 6-8 weeks.
@ambersingh4889
@ambersingh4889 2 года назад
awesome mehnat!!!!!
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks ✌️
@rajeevgosavi4514
@rajeevgosavi4514 2 года назад
Rishabji, Thank you very much for imparting such a valuable knowledge alongwith creative thinking . I also urge you to upload a complete tutorial on charts explaining in detail each and every setting and how to use them. Thank you.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Will try
@shankarbanti2250
@shankarbanti2250 Год назад
Thanks Sir Kal Hi Mujhe sir Ne bnane ke liye bolo tha
@shivamojha2846
@shivamojha2846 2 года назад
great knowledge sir,
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Keep watching
@bhaskarkansal8050
@bhaskarkansal8050 Год назад
Hi Rishabh, salute to your kind efforts and knowledge. request you to please upload excel sheet for practice as well.
@sisirmcops
@sisirmcops 10 месяцев назад
I liked the way you structured the content..... pls request you to make a detailed vedio on Gantt chart..... thanks
@rjraviraftarup7553
@rjraviraftarup7553 2 года назад
i enjoyed watching the video
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks for the visit
@Shubham-xy6xh
@Shubham-xy6xh Год назад
Kaam ki video thi sir
@AmitGupta-bl2iu
@AmitGupta-bl2iu 2 года назад
Best explanation sir you are best Indian🇮🇳 Mentor
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thank you
@bawarsher6048
@bawarsher6048 2 года назад
Nice sir I am Bawar Sher from Pakistan....
@rishabhpugalia9281
@rishabhpugalia9281 2 года назад
Shukriya
@ankitfinance357
@ankitfinance357 2 года назад
Great! Rishab Sir, you taught short and sweet way Amazing😍. I never seen such as you present. I watched twice this video I am Love in it. Is it part of MIS too sir? How can be more creative?
@nitinladke2448
@nitinladke2448 2 года назад
It was excellent video on charts.please next video on dashboard chart.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Click here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9GlrT6SdpIg.html
@surendrajaiswal8935
@surendrajaiswal8935 2 года назад
its just Amazing Rishab , Thank you very much for sharing a great knowledge, my request is - can you make a video by adding buttons on this chart to make a dashboard
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Click here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9GlrT6SdpIg.html
@hiradharsahu7019
@hiradharsahu7019 2 года назад
जोहार
@vikaasb2016
@vikaasb2016 2 года назад
Grt
@hari60700
@hari60700 2 года назад
Very nice video rishab sir.When can we expect Power BI complete tutorial from you sir.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Next 2 to 3 Months
@vijayk2250
@vijayk2250 4 месяца назад
👌👌👌👌👌👌
@MilitaryAcademy
@MilitaryAcademy Месяц назад
@surajit.worlds
@surajit.worlds 2 года назад
sir, plz do a video on the dynamic charts..& using the choose formula..that automatic change chatrs when the value is change
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Click here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9GlrT6SdpIg.html
@govindkushwah6019
@govindkushwah6019 3 месяца назад
👍
@Toon2ube
@Toon2ube Год назад
Hi sir, How can we plot real time data in chart for example stoke price with time in real time
@atifrajput1742
@atifrajput1742 2 года назад
AOA Sir ek sth value minus kese krte btadyn
@rajeshrawat4073
@rajeshrawat4073 4 месяца назад
Sir chart graphs samjh nhi aate koe video banayo
@atulsaini8697
@atulsaini8697 2 года назад
Hello sir ek course ms Word hindi me bhi bana do
@rishabhpugalia9281
@rishabhpugalia9281 2 года назад
Mere dhyaan mey hai. Agle 3-5 weeks mey.
@atulsaini8697
@atulsaini8697 2 года назад
@@rishabhpugalia9281 ok sir 😊🙏
@krunalnavle7783
@krunalnavle7783 11 дней назад
Nice lect sir how i get excel pratice file
@rjraviraftarup7553
@rjraviraftarup7553 2 года назад
⭐⭐⭐⭐⭐
@Dhundkari10
@Dhundkari10 6 месяцев назад
How u Download this Excel file for Trial
@hitubhaiya2175
@hitubhaiya2175 Год назад
practice file ki link kidhar hai?
@entertainmentkidukan5888
@entertainmentkidukan5888 2 года назад
boss please make a telegram group and share the invitation link so that we all connect with their directly and ask excel issue there only
@beingfijian1855
@beingfijian1855 Год назад
There is no practice file link. Please upload it.
@piyushagarwal5703
@piyushagarwal5703 2 года назад
Sir kindly help me out gstr 2a, gstr 2b and account purchase compare the data it's help me in gst
@asifhussain4617
@asifhussain4617 Год назад
Can you share sample data for these charts
@AsifIqbal-sz7ii
@AsifIqbal-sz7ii 2 года назад
Hello sir, Whenever I use formula like vlookup or sumifs,the actual results are exactly shown in sheet but when I close the source file then it shows #value sign in relevant cells. Kindly share the solution how to fix this problem.
@Userk2406
@Userk2406 5 месяцев назад
15:57
@shivanisharda3112
@shivanisharda3112 2 года назад
Sir, Do you have any certificate advance excel course ?
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Yes, we have Click here for more details - courses.excelsuperstar.org/s/store/courses/description/excel-mastery-program-in-hindi
@rahulborda
@rahulborda 2 года назад
More knowledge about Normalisation ..
@thethethdeshi
@thethethdeshi 2 года назад
Add Charts video to paid course pls.. Update the paid course with Charts & dash board videos.. Pls
@rishabhpugalia9281
@rishabhpugalia9281 2 года назад
It ll be done in 48 hrs.
@thethethdeshi
@thethethdeshi 2 года назад
@@rishabhpugalia9281 Thank you sir.. Thank you from the bottom of my heart😍😍.. Sir I am your biggest fan. Maine apke teeno course buy kar rakhe hai, excel, vba & power Point.. "Sir yahi request hai ki excel course mein "Charts & dashboards" ki videos update kar de".. pls
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Already done please check your course access account.
@mohammadshahbazakhtar8740
@mohammadshahbazakhtar8740 2 месяца назад
I need ur help
@veenagupta9716
@veenagupta9716 Год назад
practice sheet nhi daali hai
@safashaikh2894
@safashaikh2894 2 месяца назад
Yes
@waniashfaq123
@waniashfaq123 2 года назад
I want to chart for four years data
@rishabhpugalia9281
@rishabhpugalia9281 2 года назад
Column, Line
@swapniljadhav5249
@swapniljadhav5249 2 года назад
Do then
@sunilmartis4706
@sunilmartis4706 2 месяца назад
@aliimran5696
@aliimran5696 2 года назад
Dear sir I am from Pakistan 🇵🇰 and big fan of yours I can't buy your course please gift me as good gesture.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Checkout our RU-vid Channel you will get *FREE learning*
@pankajagarwala1895
@pankajagarwala1895 2 года назад
Thanks Rishabh, keep doing good work! God bless you.
@ExcelSuperstar
@ExcelSuperstar 2 года назад
Thanks
Далее
Dynamic Excel Dashboard [Raw Data to Excel Dashboard]
32:20
MS Excel - Pie, Bar, Column & Line Chart
8:56
Просмотров 1,1 млн
Quick 3D Container Chart in Excel
15:12
Просмотров 85 тыс.
Excel Charts and Graphs Tutorial
24:31
Просмотров 481 тыс.
Excel Charts Basic to Advanced- Revision
29:56