Get Ahead With These 10 Advanced Excel Charts!

Поделиться
HTML-код
  • Опубликовано: 23 июл 2024
  • 10 different advanced Excel charts: what type of data to use with them, when to use them, and the advantages they provide over traditional charts.
    -- LINKS --
    DOWNLOAD THE WORKBOOK ► www.excelcampus.com/charts/10...
    ** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM**
    www.excelcampus.com/join-elevate
    --
    ~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) www.excelcampus.com/blueprint ~
    ~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: www.excelcampus.com/newsletter/
    0:00 Intro
    0:58 1. Column Chart with Percentage Change
    1:49 2. Conditional Donut Progress Chart
    2:22 3. Interactive Histogram with Details
    3:14 4. Dynamic Histogram or Frequency Distribution Chart
    4:28 5. Annual Trend with Monthly Details
    5:39 6. Interactive Waterfall Chart
    6:43 7. Variance on Clustered Charts
    7:26 8. Actual vs. Multiple Targets Chart
    8:05 9. Stacked Bar with Dynamic Data Labels
    9:24 10. Comparative Distribution Chart
    10:13 11. Bonus: Zoom on Charts Macro
    **********
    EXCEL FRIENDLY ACCESSORIES WE USE (Affiliate Links When Possible): LOGITECH KEYBOARD
    Check out all the tech we use and recommend at www.excelcampus.com/store
    **********
    -- Related Content --
    - Progress Circle Chart in Excel: • Progress Circle Chart ...
    - Column Chart That Displays Percentage Change in Excel: • Create A Column Chart ...
    - Actual vs Targets Chart in Excel: • How To Create An Actua...
    - How to Create an Interactive Histogram Chart that Displays the Group Details: • How to Create an Inter...
    Please leave a comment below with info on what type of chart you'd like to see a tutorial on, or explain what type of data you have. Thanks! 🙂
    #MsExcel #ExcelCampus

Комментарии • 201

  • @rembautimes8808
    @rembautimes8808 2 года назад +1

    Wow very innovative. I have been referring to this channel at least 10 times over the recent history. What I like about all these charts is the ability to present multiple pieces of related information in a single visualization. And I have deep admiration about how Jon looked at a chart he found intuitive and then gradually perfected it - a true work of a master craftsman.

  • @luistrejo2987
    @luistrejo2987 3 года назад +3

    The Variance on Clustered charts is exactly what I have been looking for, thank you SO much!

  • @Dose1428
    @Dose1428 3 года назад +1

    I can't properly express how helpful and awesome your videos are. I've made them essential review assets for my team. Thank you!

  • @yaxmokwa7612
    @yaxmokwa7612 3 года назад +1

    The most resourceful Excel charts video for the year so far. Thank you for doing this.

  • @diannedrechsler4792
    @diannedrechsler4792 3 года назад +3

    Wow Jon, these charts are incredible! Can't wait to try some of them out.

  • @marcalleranthonyguevarra7459
    @marcalleranthonyguevarra7459 3 года назад +2

    Your videos are really helpful! They are well presented and easy to understand. May I know if you have video tutorials for Annual Trends with Monhly Details Dashboard and Interactive Waterfall Chart? I would love to be able to use those types of graphs too. Many thanks and stay blessed!

  • @lisaamante5384
    @lisaamante5384 3 года назад +1

    Las Vegas, NV, USA: These are so very awesome!! Thank you so much!

  • @SolidSnake59
    @SolidSnake59 2 года назад +1

    This is SOO cool. Thank you! I like that you quickly show all charts and don't go into details.

  • @Nttphuonghy
    @Nttphuonghy 3 года назад +3

    this is my first time here. thank you so much for the amazing advanced charts. Im really interested in Actual vs. Multiple Targets Chart. Hope you will make a video to use this kinda amazing chart.

  • @amirahmadi8261
    @amirahmadi8261 2 года назад +2

    Hi Jon🌷
    All chart are totally designed well and so practical.👌🏻
    Thanks a bunch for sharing 🙏🏻
    Would it be ok if you teach us how can we design every chart like those?
    Thanks 😊

  • @theblackswan3757
    @theblackswan3757 Год назад +1

    This is an awesome presentation. It's going to make my project super dope. Thanks Jon! 🙂

  • @ohhapyday3977
    @ohhapyday3977 3 года назад +1

    Awesome and straight to the point 🙌🏼

  • @vipulDJhaveri
    @vipulDJhaveri 3 года назад +1

    Speaking figures, thanks Mr.Jon for
    sharing this amazing ideas

  • @mohammedelsakally540
    @mohammedelsakally540 7 месяцев назад +1

    After two years of releasing this video i'm really so much appreciated the knowledge you always providing to your followers... thank you Jon.

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

      Great to hear that. 😀

  • @conradhaynes4672
    @conradhaynes4672 2 года назад +1

    Superb presentation. Thank you. I would be interested in graphs (box plot, normal and binomial distributions) linked to statistical data analysis / probability modelling.

  • @TheSardOz
    @TheSardOz 3 года назад +1

    Hi Jon, I would love to see a tutorial when you do a overlay of 2 charts, a intraday stock chart of one minute frame with the overlay of buy and sell positions to highlight entry and exit of a trade. I can send you to data if you are keen ... thank you for your videos, they are very helpful for learning !

  • @gauthierfamily7140
    @gauthierfamily7140 3 года назад +1

    Jon, you are one of the best Excel gurus out there! Awesome charts.

    • @ExcelCampus
      @ExcelCampus  3 года назад

      Thank you! I really appreciate your support. 🙌

  • @InzideEntertainment
    @InzideEntertainment 4 месяца назад

    Thanks. Hope I can keep finding more as I go!

  • @silviafigueroa1312
    @silviafigueroa1312 Год назад +1

    You explained very well… it is easy to understand. 🙏🏻🙏🏻

  • @wararkacaalamka8102
    @wararkacaalamka8102 2 года назад +2

    deserved to like for my first time while watching les then 10 minute. thank you

  • @maherahmed2018
    @maherahmed2018 2 года назад +1

    Spectacular! I am so lucky that I am subscribed and found such astonishing Visualisation tips

  • @YouExcelTutorials
    @YouExcelTutorials 3 года назад +1

    Awesome stuff Jon! Thanks for sharing.

  • @John-tw6dc
    @John-tw6dc Год назад +1

    Thank you so much! this is very educational and helpful.

  • @aidacurraj8804
    @aidacurraj8804 3 года назад +1

    Excellent explanation, thank you very much

  • @lukev730
    @lukev730 2 года назад +1

    Amazing ideas
    Thank You Jon

  • @azizadily1595
    @azizadily1595 Год назад +1

    You are the best. Great teacher.

  • @cshahed
    @cshahed 2 года назад +1

    Great charts Jon, many thanks :)

  • @rogeriooliveira4934
    @rogeriooliveira4934 3 года назад

    Hello, I would like to thank you for your contributions and work on RUclips. Would you please have any other material in excel that you don't have on RUclips to share sales versus forecast accuracy? Thank you so much

  • @judywilder7883
    @judywilder7883 3 года назад +1

    The Zoom on Chart macro would be great to implement in a report I am working on now!

  • @cherianiype
    @cherianiype 3 года назад +1

    @Excel Campus - Jon --- this is top class stuff man! Really great! Starred, liked, loved! Woot woot! Super stuff Jon. Thanks man! Appreciate this video! Cherian from Abu Dhabi

  • @dorothythompson2553
    @dorothythompson2553 3 года назад +59

    This is excellent data. It would be good to know how to create them step by step

  • @patrickmarfo7808
    @patrickmarfo7808 4 месяца назад

    Love this

  • @johedennyssantanamontero4858
    @johedennyssantanamontero4858 3 года назад +1

    Suscribed! Yes sir! This is awesome!!

  • @thecandyman2812
    @thecandyman2812 3 года назад +1

    Thank you for these tutorials. Every one is so useful and most of these excel features are unknown and unused.

  • @hayleybrown2726
    @hayleybrown2726 2 года назад

    Hi, Great video so thank you. im trying to create a chart depicting weekly lead times and if they increase/decrease. whats the best practise to show this so I can see this quickly?

  • @markkelly9686
    @markkelly9686 Год назад

    Thanks so much for sharing Jon - this is the best channel on You Tube for Excel turorials and tips !!!!

    • @ExcelCampus
      @ExcelCampus  Год назад +1

      Thank you Mark! I really appreciate your support. 😊

  • @allison447
    @allison447 Год назад

    like those mini to expandable charts. I've never made that one before. You might put the doughnuts into a gauge chart. They turn out pretty nice for top level data. I'd like to see a few of these initial charts how to. There might be some shortcuts you use to save some time in creation

  • @belkisrios4607
    @belkisrios4607 2 года назад

    Hi,
    Good summary and amazing charts...
    I have a data with multiple products that I have to show target vs actual YTD and cumulative... which chart can I use considering those conditions?

  • @farhanasacha970
    @farhanasacha970 Год назад

    Hi Jon - Really enjoying your videos. I am becoming a little stuck with being able to accurately report on conversion rates by Account Manager, especially as we have 10 different stages in Salesforce. Essentially I am looking to get a percentage conversion rate on Program Confirmed with Done - Successful vs all 8 other Stages. I have consolidated data per Account Manager and then have created a Pivot Table by individual Account Manager with Stage and sum of expected revenue. Do I then need to create another table to further consolidate? Or is there a way in Power Query that can allow me to do this? I have been playing around with this for the past two days now and cant seem to figure out a way that makes sense. Looking forward to hearing your thoughts/advice :)

  • @wayneedmondson1065
    @wayneedmondson1065 3 года назад +3

    Awesome Jon! Your links to the tutorials for the charts featured in the video almost constitute a charting mini-course. Thanks for sharing all these great tips and features. Looking forward to digging into each one in more detail. Thumbs up!!

    • @GrainneDuggan_Excel
      @GrainneDuggan_Excel 3 года назад +1

      Wayne, thanks for the reminder to check out the other chart videos. You are right about them being a mini-course. They leave you eager for more chart video's

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

    Hi Jon, greatly appreciate your videos that simplifies excel!! How and when can i use a Radar chart.

  • @darrylmorgan
    @darrylmorgan 3 года назад +1

    Cool Tutorial!! Great Explanation Of Data Type's And What Chart Is Best To Tell The Data Story...Thank You Jon :)

  • @yogeshlahoti2149
    @yogeshlahoti2149 2 года назад

    Hi Jon, charts were very insightful. I am trying to build a Column Chart with 2 variables (Revenue & Gross Profit) and variance for both variables with an Arrow mark. Is there way to build this in excel ?

  • @clivepetty2338
    @clivepetty2338 3 года назад +1

    Jon thanks sharing some helpful

  • @SlametPundya
    @SlametPundya 3 месяца назад

    Excellent video!! Keep a good work.

  • @K9Syndicate
    @K9Syndicate Год назад

    Hi John, any chance you can show how to visualize a how long different types of products will last using a stacked column chart with a calender as the x-axis? thanks.

  • @ramdashwant2024
    @ramdashwant2024 3 года назад +1

    Very beautifully explained 💗🎊💖❤️😘

  • @rotethongvanit
    @rotethongvanit 2 года назад +1

    Brilliant!

  • @conradblume4274
    @conradblume4274 3 месяца назад

    Excellent video!!

    • @ExcelCampus
      @ExcelCampus  3 месяца назад

      Thank you very much! 😀

  • @thanhhung6201
    @thanhhung6201 2 года назад

    If you don't mind me saying, you are an excel magician!

  • @cursors7866
    @cursors7866 3 года назад +1

    You guys are super genius

  • @carmelitamartin1157
    @carmelitamartin1157 3 года назад +1

    Can you please create a dynamic chart for a weekly sales comparison against last year sales on a weekly basis as well

  • @Dhavekost
    @Dhavekost 3 года назад +1

    USEFUL. VERY USEFUL

  • @challengegopi3553
    @challengegopi3553 3 года назад +1

    Excellent....

  • @vidyak1890
    @vidyak1890 Год назад

    Hi, Saw your tutorial on Actual vs Target Charts that was great learning. I have a query, if I have say 3 nos. of criteria bars is it possible to overlap just two of them.

  • @forex_for_everyone4270
    @forex_for_everyone4270 Год назад +1

    Woa,amazing sir...!

  • @krishnakd1980
    @krishnakd1980 3 года назад +1

    Excellent

  • @micw3992
    @micw3992 3 года назад +1

    Great video

  • @patmcluvn5859
    @patmcluvn5859 2 года назад +1

    This is the best video EVER

  • @taasho1986
    @taasho1986 3 года назад

    How about showing percentage changes on 5th chart? We can see highlighted year but is it possible to see variance at the same time ? Thanks.

  • @AlexandreBCosta
    @AlexandreBCosta 3 года назад +1

    Excelent point of view!!!!

  • @DonLeon507
    @DonLeon507 Год назад

    Super helpful information !! thank you

  • @ulfmalmquist9162
    @ulfmalmquist9162 3 года назад +1

    Hi, thank you for the beautiful video, I'm interested in Donut Progress Chart. Greetings from Stockholm

  • @lionels839
    @lionels839 2 года назад

    Hello. Great tips. I am a french engineer and I would be interested In doing Pareto, gaussian and other statistical charts to help me identify hidden trends and show the big pictures in my charts (using thousands of historical data)…Also, It would be great if Excel could help identify two or more dependant variables out of dozens. For example, 365 rows from 1/1 to 12/31 (historical) and 10 variables in 10 columns. What are the dependant variables (those related), that is the ones that have a similar pattern or reverse pattern? Big challenge?

  • @ACES_NY
    @ACES_NY 2 года назад

    Do you have a view that shows how you changed the size of the charts. That VBA would be helpful

  • @nkechilaura4832
    @nkechilaura4832 Год назад

    Hi Jon, this is great. Can you share the link to the video tutorial for chart 5-Annual trend with monthly details

  • @vijaysahal4556
    @vijaysahal4556 3 года назад +1

    superb 👍🏻👍🏻👍🏻👍🏻

  • @sbutinaful
    @sbutinaful 3 года назад +1

    Hi I am interested in forcasting, predictive analysis, and by the way thisnis amazing.

  • @nasseralhajri543
    @nasseralhajri543 11 дней назад

    Yr Support greatly valued, where can i find the anuualy trend with monthly detailed pls ?!

  • @ferrygodmothergamingworld
    @ferrygodmothergamingworld Год назад

    Wow, your video was the best thing since my coffee this morning! I now have a real idea of possibilities. Thanks. I have two projects which I need to create charts for currently, one to track our video gaming team players and their performance growth. Also, I produce major community concerts, I'm working on 2023 sponsorship prospectus, I need to chart the specifics demographic for three states. I would love to have something condensed and pretty. Do you have any suggestions on the best charts to use for these two scenarios?

  • @buhawilakas4439
    @buhawilakas4439 2 года назад

    Hi Jon, can you help me with how to make a line graph for multiple products? I want the left Y-axis to indicate the product name (and not a number but the product name itself). The horizontal axis would be the months. and the left Y-axis would be sales for each product. and with a slicer, I would be able to switch different years. Hope you can help me. thanks.

  • @ApteryxRex
    @ApteryxRex 3 года назад

    Really would like to see a chord chart in Excel. Any ideas?

  • @Shremmer45
    @Shremmer45 3 года назад

    Not sure where to post this but can you do a video on using VBA with Solver ?

  • @Sandeepboi
    @Sandeepboi Год назад +1

    Great...........

  • @RahulGupta-ig9gv
    @RahulGupta-ig9gv 3 года назад +1

    Awesome

  • @muhamedhany4407
    @muhamedhany4407 3 года назад

    Hi would you pleasr advise how can I show top customers that generates negative Gross margin in dynamic dashboard.

  • @kerrybone8259
    @kerrybone8259 2 года назад

    Hi Jon, I have a data label on my columns in a bar chart. I need a second different value just at the bottom of each column. How can I do that?

  • @briannetuttle7658
    @briannetuttle7658 3 месяца назад

    Do you have a video with how to create the Variance on Clustered Charts?

  • @yawarm
    @yawarm 2 года назад

    I want to create a breakeven analysis chart. Which I did. Now need to know how to highlight the area between sales and total cost line “where the profit begins”.
    And also color the area “of loss” with another color

  • @carlobugliarello5143
    @carlobugliarello5143 3 года назад +2

    Hi, thank you for the beautiful video, I'm interested in "Comparative Distribution Chart" and " Stacked Bar with Dynamic Data Labels". Greetings from Rome, Italy. Ciao.

    • @ExcelCampus
      @ExcelCampus  3 года назад

      Thank you Carlo. I appreciate the nice feedback and it's good to know the ones you are interested in. There are links in the description where you can learn more about those charts. Thanks again and have a nice day! 🙂

  • @amitmakharia9925
    @amitmakharia9925 2 года назад

    Can we make expandable charts based on timeline? For example i want to see monthly sch vs. supply data and when i goto to any month it expands and shows that month graph?

  • @jainthomask756
    @jainthomask756 3 года назад

    Hi Jon. I'm bit confused to create a chart. There are four columns, projects no, amount, project managers and the status of project. I just want a bar chart that show the percentage of project approved and not approved.

  • @madhavgotecha5148
    @madhavgotecha5148 3 года назад

    Hi Jon,
    How would I be able to make a Pareto doughnut chart by pivot table/chart.
    Where 20% = Products
    80% = Revenue.

  • @RafatHamid
    @RafatHamid Год назад

    very interesting, especially for the Interactive Waterfall Chart. how to find the tutorial?

  • @godkrakenamv2321
    @godkrakenamv2321 2 года назад +1

    Superb

  • @alisonmiddleton1122
    @alisonmiddleton1122 2 года назад

    would love to know how to add multiple commentary on a chart that goes above dates taken from a commentary table

  • @marshmallow1208
    @marshmallow1208 3 года назад

    What chart would be best for accounts receivable trends?

  • @KingFahad88
    @KingFahad88 2 года назад

    Very informative. However, I'm looking to create a static chart that shows the burn down of progress. Essentially we have X amount of clients that we need to onboard within the next 6 months, but no fixed dates. The three categories I want to show are "No Movement", "Assessment Completed", "Onboarded". So far I have not been able to find a chart that visualizes the way I'd like. Any ideas? Thanks in advance!

  • @TheBatey1
    @TheBatey1 3 года назад +4

    A chart to track weekly utilities that then go to month and then a yearly regression.

  • @alaakhalil7337
    @alaakhalil7337 2 года назад

    hi, can you make a video on microbiome relative abundance barplots

  • @bearded.broker
    @bearded.broker Год назад

    I'm not sure which charts would be the best, but I'm analysing 6500 lands sold in cottage country near me in Montreal Quebec. Lands are all types and sizes. I've selected the residential ones and multiple pivot tables for different size categories. I'm looking at average size, sale price and $ per SF for each of these categories and wondering how best to display them in charts. I'd love to get some help to take them to the next level

  • @carolinokim
    @carolinokim 2 года назад

    Hello sir, how to create two different x and y axis for historical data of a stock?

  • @muhammadmudassir131
    @muhammadmudassir131 2 года назад +1

    Nice videos sir

  • @khoioanhvu
    @khoioanhvu 3 года назад +1

    Could you made another video to share how to draw these charts? They are really amazing 😍

    • @ExcelCampus
      @ExcelCampus  3 года назад +2

      Hi Khoi, Thank you for the suggestion and feedback. We do have videos for some of the charts and blog posts for all of them. Here is a link to the post with all the links to each tutorial.
      www.excelcampus.com/tools/zoom-on-excel-charts/
      However, we will add videos on the others in the future. I hope that helps. Thanks again and have a nice day! 🙂

    • @khoioanhvu
      @khoioanhvu 3 года назад

      Many thanks for your kind 😍

  • @GrainneDuggan_Excel
    @GrainneDuggan_Excel 3 года назад +2

    I would love a charts course that covered step by step for all these charts and techniques! Sign me up when you offer it
    Beautiful charts with useful features Jon

    • @ExcelCampus
      @ExcelCampus  3 года назад +1

      Hi Grainne, we do have Elevate Excel course which is a comprehensive (beginner-to-advanced) online training program that covers everything you need to drastically improve your Excel skills, save tons of time with your job, and become the Excel Hero of the office. You may join us by following this link www.excelcampus.com/join-elevate/

    • @ExcelCampus
      @ExcelCampus  3 года назад +1

      I should have mentioned that our Elevate program does not cover all of these charts yet. However, I think it's a great idea and will add this to the list for future program updates. We do have a section in the program on charts, dashboards, and data visualization principles that covers more of the basic chart types and when to use them.

    • @GrainneDuggan_Excel
      @GrainneDuggan_Excel 3 года назад

      @@ExcelCampus thanks for the link. By your site's definition, I fall in the Excel master category - I would never use that term. I am hoping you will offer an advanced charts stand alone course. Your charts display the data so clearly, simply and are pleasing to the eye.

  • @sunnybaggu785
    @sunnybaggu785 2 года назад

    Hii...Can we draw a tetrahedron with known 3d (x,y,z) coordinates in excel chart

  • @ianmurdoch6315
    @ianmurdoch6315 Год назад

    Do you have a tutorial for the interactive waterfall chart

  • @onesimonkomo2885
    @onesimonkomo2885 2 года назад

    I need a formula to maintain a sequence of numbers based on other fixed numbers, can i get help on that

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

    Hey, could you please make a video on the Annual Trend and Monthly details graph. All these graphs are so so good. I’ve tried to look for this Trend graph video, but i couldn’t find it. And then I found your website and could not understand how to make it from your written tutorial either. It would really be so helpful if you could make a video on it! Hoping that you will soon! ❤

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

      Also, I really want to thank you for opening this whole world for us average users. This really amazed me and opened my mind about how to present the data I have.

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

      Hi Not Comfortable! 😀 You can download the workbook on that monthly-average-vs-current-year page on the Excel Campus website to follow along with that tutorial. Feel free to change the data to suit your needs. Hope that helps! 😊

  • @dleven2013
    @dleven2013 Год назад

    Jon I have to compare data from three different cities over three years, do I need to do one chart for each year or is there a way to show all three years on one chart? thanks