10 Advanced Excel Charts and Graphs (Creating from Scratch) | FREE Excel Course

In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts and graphs in Excel.

The following advanced Excel charts examples are covered in this video:
-- Multi-Category Charts
-- Gauge Chart
-- Thermometer Chart
-- Milestone Chart
-- Water Fall Chart
-- Gantt Chart
-- Chart with Trend Arrows in Data Labels
-- Actual Vs. Target Values
-- Spotting Data in a Scatter Chart in Excel
-- Dynamic Target Line in Excel Bar Charts

There a lot of advanced charting technique shown in this video and you can use the same techniques to create more types of advanced charts in Excel.

In most cases, you will notice that an advance chart is nothing but a regular chart that is dependent on the cells in Excel. And these cells are dynamic as these have formulas.

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[Sai_Srikar_Panjala]

The living LEGEND, Sumit Bansal !!! You are a God among men to all techno-idiot, passing themselves off as Excel as all great artists, underappreciated in their time. Cheers to you, old friend!

[sowmyasankar]

Hi Sumit - Thank you for sharing your knowledge with us. God bless you 👏

[stevenlitvintchouk]

Excellent tutorial. On my own, I would never have figured out how to make a gauge chart. Never.

[drz]

thank you for these beautiful charts you're working on . you are making a really great effort teaching these charts!

[wayneedmondson]

Hi Sumit.. great lesson. I especially like the Dynamic Target Line Bar Chart. Thanks for sharing this video. Thumbs up!

[nickissaev]

Beautiful, beautiful charts!!! Thank you sooo much for sharing! Amazing job!!!!

[Faiz]

This was Amazing, so much information in one video. Thank You💯

[debaduttamishra]

Very nicely explained. It helped to improve my presentation slides.

[govindanvr]

Very nice way you are explaining, thank you sir.

[naushadnm]

Thanks for all your effort Bro. Hope you get something out of this from YT.

[neelneelam]

You are amazing Sir. Realey you are excel expert

[No_One_Channel]

I have learned a lot from this Sir, thank you so much!

[qybl]

Hello,
the VLOOKUP for the ScatterChart (38:00) needs its range lookup parameter set to FALSE (exact match only).
Thank you Sumit for these great courses! I am learning so much :)

[johnfmather]

Thanks! These are great. They are very useful and extremely well explained and demonstrated. I shall use these impressive charts of yours and take credit for them at my place of employment. 😀

[Ricardotto]

Some really smart charts here. Learnt a lot, let me see how I can apply these to some of my stuff.

[AAA-mqjj]

awesome video, need to practice these !!

[bobnzambe]

Thank you so much for this technical support and I really appreciate

[houstonchinesealliance]

great tutorial, thanks much for sharing!

[danielcollins]

Thanks for the tutorial! Just saying a Tomato is a fruit though not a vegetable

[spuneet]

Thanks, i am already using few of them and few other than these