The Variance on Clustered charts is exactly what I have been looking for, thank you SO much!
@yaxmokwa76123 жыл бұрын
The most resourceful Excel charts video for the year so far. Thank you for doing this.
@SolidSnake592 жыл бұрын
This is SOO cool. Thank you! I like that you quickly show all charts and don't go into details.
@silviafigueroa13122 жыл бұрын
You explained very well… it is easy to understand. 🙏🏻🙏🏻
@wararkacaalamka81022 жыл бұрын
deserved to like for my first time while watching les then 10 minute. thank you
@maherahmed20182 жыл бұрын
Spectacular! I am so lucky that I am subscribed and found such astonishing Visualisation tips
@theblackswan37572 жыл бұрын
This is an awesome presentation. It's going to make my project super dope. Thanks Jon! 🙂
@wayneedmondson10653 жыл бұрын
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_Excel3 жыл бұрын
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
@thanhhung62013 жыл бұрын
If you don't mind me saying, you are an excel magician!
@ohhapyday39773 жыл бұрын
Awesome and straight to the point 🙌🏼
@cherianiype3 жыл бұрын
@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
@cshahed2 жыл бұрын
Great charts Jon, many thanks :)
@dustywilson5461 Жыл бұрын
Excellent presentation. While you're not a fan of the stacked bar chart concept, I think it'll be an excellent tool for gauging finances.
@thecandyman28123 жыл бұрын
Thank you for these tutorials. Every one is so useful and most of these excel features are unknown and unused.
@cursors78663 жыл бұрын
You guys are super genius
@JSUG42193 жыл бұрын
Jon, I love this - thank you so much. 2 questions: 1) You mention the Bonus Zoom macro, but did I miss the link to the actual macro? 2) On Chart 3, the Slicer buttons are in the correct order (0-99, 100-199, etc.), but the bars are not sorted correctly (they are 100-199, then 0-99, etc.). Other than that, great video, with lots of useful info!
@ExcelCampus3 жыл бұрын
Thanks Jack! Here are my answers. 1. Here is the link to the post for the Zoom on Charts macro. www.excelcampus.com/tools/zoom-on-excel-charts/ We'll add all the links in the description above. 2. Great spot! Thank you for letting us know. It looks like the sorting is out of order on the underlying pivot table. We'll get this updated. Thanks again and have a nice day! 🙂
@JSUG42193 жыл бұрын
@@ExcelCampus Thanks, Jon. Again, great stuff and I appreciate the link for the zoom macro.
@clivepetty23383 жыл бұрын
Jon thanks sharing some helpful
@DonLeon507 Жыл бұрын
Super helpful information !! thank you
@ExcelCampus Жыл бұрын
Happy to help!
@conradblume42745 ай бұрын
Excellent video!!
@ExcelCampus5 ай бұрын
Thank you very much! 😀
@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?
@DJ1973DZ3 жыл бұрын
The truth is that you diserve a millions of subcribers, while we can see some pages on youtube with none/zero content and got millions of fellows ? Really strange this.
@challengegopi35533 жыл бұрын
Excellent....
@nkechilaura4832 Жыл бұрын
Hi Jon, this is great. Can you share the link to the video tutorial for chart 5-Annual trend with monthly details
@ACES_NY2 жыл бұрын
Do you have a view that shows how you changed the size of the charts. That VBA would be helpful
@AlexandreBCosta3 жыл бұрын
Excelent point of view!!!!
@ExcelCampus3 жыл бұрын
Thanks Alexandre! 🙂
@K9Syndicate2 жыл бұрын
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.
@krishnakd19803 жыл бұрын
Excellent
@yawarm2 жыл бұрын
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
@KingFahad882 жыл бұрын
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!
@ahmadhassanbakr Жыл бұрын
Thanks for the video, charts and ideas look amazing. I followed the link in the description but this resulted in me receiving an email from your side containing other material than the charts files. How can I receive the file containing these charts?
@ExcelCampus Жыл бұрын
Hello @ahmadbakr3738 you can download the file from the Downloads section of the blog post after you enter your name and email address. Thanks! 😀
@ahmadhassanbakr Жыл бұрын
@@ExcelCampus Thank you for your response. I did, and I received and email with a zip file containing the book and an excel sheet, but it was not about the contents of this video, the material was much more for beginners rather than the level in the video.
@ExcelCampus Жыл бұрын
I'm sorry about this. We're looking into the issue. Here is a link to the download. www.excelcampus.com/wp-content/uploads/2021/03/10-Advanced-Excel-Charts.xlsx I hope that helps. Thanks again and have a nice weekend! 🙂
@godkrakenamv23212 жыл бұрын
Superb
@shivanisaroha7571 Жыл бұрын
Can you please how to graphically present sales of 4 years of a certain group of product like drinks and comparing its quantity sold, cost price, selling price, profit each year.
@shivanisaroha7571 Жыл бұрын
Drinks also minimum 50
@louisewooding124 Жыл бұрын
HI Jon. I have tried to download the workbook - when I click onto the link it has installed WinZip system tools but I still don't have the file? AM I doing something wrong? Love your videos! Thank you, Louise
@muhammadmudassir1312 жыл бұрын
Nice videos sir
@usmanafzal4288 Жыл бұрын
Hi Jon, Thanks for the amazing video, great inspiration! I have a question, though. In chart 7 (7:24) how on earth do you conditionally format the variance chart to switch between red/green? Do you invert colors if negative, in the formatting options? And you have made the width of the variance column a bit larger, do I understand correctly?
@usmanafzal504 Жыл бұрын
Ignore above, just saw there is a tutorial for each graph
@belkisrios46072 жыл бұрын
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?
@alvc222 жыл бұрын
How do you make a chart showing which hours of the day you slept, ie one day you slept from 11 to 6 another 3am to 12 pm. So the vertical axis shows the 24 hour day and the horizontal axis shows the date so you can see over a whole month the variation in sleep schedule.
@jainthomask7563 жыл бұрын
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.
@ApteryxRex3 жыл бұрын
Really would like to see a chord chart in Excel. Any ideas?
@IwantElvisHair2 жыл бұрын
I need to create a chart that shows the calorie content per portion of products in a range and my manager wants to see a line that shows the average calorie content. What is the best way to show this?
@yogeshlahoti21492 жыл бұрын
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 ?
@undefeatablesaheb66482 жыл бұрын
This is great- but I need to make a stacked bar chart and am super lost!
@rukmagar-v1z2 жыл бұрын
how do you create a link with the multiple chart. One click all trend moves in all the chart exist in one sheet eg slicer to be used etc
@madhavgotecha51483 жыл бұрын
Hi Jon, How would I be able to make a Pareto doughnut chart by pivot table/chart. Where 20% = Products 80% = Revenue.
@CarlosSantos-mz1kj3 жыл бұрын
Dynamic Histogram, would like to know how???
@ExcelCampus3 жыл бұрын
Hi Carlos, Here is a link to the post that explains how to create it. You can download the sample file there as well. www.excelcampus.com/charts/dynamic-histogram/ I hope that helps. Thanks again and have a nice day! 🙂
@CarlosSantos-mz1kj3 жыл бұрын
@@ExcelCampus thank you very much Jon!
@sunpreetsinghanand6005 Жыл бұрын
Is there an email i can share my data and take your suggestions on some charts or dashboards
@argharoy64138 ай бұрын
I have 1 ratio, for 120 months, for multiple fund. How can I show it in one chart which will not look too busy,?
@ExcelCampus8 ай бұрын
Hi Argha! 😀 A line chart, with the entire timeframe on the horizontal axis, should not look too busy, if you only have 1 line. You could also use the Annual Trend with Monthly Details charts listed 5th in the video beginning at the 04:30 mark. The Source URL shown under the graphs in the video leads you to a page to walk you through how to make those charts. Hope that helps!
@abelchacha59772 жыл бұрын
How can I move more than one column from one sheet to another at once?
@muhammadfaras8529 Жыл бұрын
Hello how do we create these charts?
@arvindprovinchandra12982 жыл бұрын
Where is the button to download your presentations???
@salmankhan-ln5ku3 жыл бұрын
hey, what I need help on I am a trainer we have assessments pre & post during training for multiple regions in a month (how to track individual performance and how to show dashboard which will be easy for CEO to understand)
@yahyaalsulaiman97052 жыл бұрын
Hey bud.. can you share the excel file on which you created these charts !?
@ExcelCampus2 жыл бұрын
The following link is to the accompanying blog post that contains links to all of the posts, videos for each chart and the downloadable file www.excelcampus.com/charts/10-advanced-charts
@yahyaalsulaiman97052 жыл бұрын
@@ExcelCampus thx a lot
@ji97873 жыл бұрын
Hi i want to add text inside the column not data label
@bokuto398710 ай бұрын
Just leaving some timestamps for myself to see later 2:32 10:22
@sonjuhisharma1392 жыл бұрын
Hi Can you help in teaching these great charts
@kockerbarbazuah568410 ай бұрын
how to trend graph in excel
@kondembehsesay64873 жыл бұрын
How to create them step by step?
@JUSTINOPERAZA Жыл бұрын
como obtener la base de datos
@ExcelCampus Жыл бұрын
You may download the file from this link www.excelcampus.com/charts/10-advanced-charts 😀
@shashikantm91352 жыл бұрын
Sir but I don't know how did I get
@SanviPatil20193 жыл бұрын
Plz give me all new formulas in excel 2019 windows 7 32 bit.. xlookup, xmatch, filter, sort, uneque, switch, etc all new formula.. plz give me all new formulas add ins for excel 2019
@ExcelCampus3 жыл бұрын
Thanks for the suggestion Vikas! We'll add this to our list for future videos.
@SanviPatil20193 жыл бұрын
@@ExcelCampus in ms office 2019 all above formula not showing. So plz all formulas add ins for ms office 2010, 2013, 2019 given.
@dorothythompson25533 жыл бұрын
This is excellent data. It would be good to know how to create them step by step
@johedennyssantanamontero48583 жыл бұрын
Follow the link, their blog has more info.
@lazyreviewssupport98115 ай бұрын
0:22 mine is a simple one... There's a class full of students There are 4 subjects M, P, C, Z Every 2 or three days there's a test on the above subjects. (dates are available) We need to capture how each student progress in each subject. Additionally we need to capture how each student perform in comparison to other. Students & subjects are constant. But number of tests are dynamic, meaning we need to add more test results as time progresses. Max mark in each sub is 180, so max total marks is 720. First I am confused 😕 how to put this data in the excel sheet, then type of chart 📊 to use to capture this data 😢... Any help would be appreciated 😊
@TheBatey13 жыл бұрын
A chart to track weekly utilities that then go to month and then a yearly regression.
@Nttphuonghy3 жыл бұрын
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.
@carlobugliarello51433 жыл бұрын
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.
@ExcelCampus3 жыл бұрын
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! 🙂
@amirahmadi82612 жыл бұрын
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 😊
@favourite22 Жыл бұрын
Hi there! Thanks for adding super video on charts. I have quick question! I have multiple sitee, each site having 5 different values in 5 coulmns pertians to 2012, the same sites are also have another 5 coulmns with different values pertains 2013. H Ho
@sudarshanbhosale9725 Жыл бұрын
Hi Really impressive
@ExcelCampus Жыл бұрын
Thanks, @sudarshanbhosale9725! 😀
@nasseralhajri5432 ай бұрын
Yr Support greatly valued, where can i find the anuualy trend with monthly detailed pls ?!
@Puru23456 Жыл бұрын
Hi Can you create chart which has multiple location A, B, C, D, E.. and quarter 1,2,3,4 and sales and number of invoices. In one chart i need the sales value along with count of invoice for 5 locations 4 quarters
@RE-xv9fp Жыл бұрын
I am all new to this and it seems for us beginners one of the most important detail is, how the data set looks to begin with. I have tried creating simple graphs and pivot graph now after a few tutorials but they all fail! I believe its because my data sets looks different somehow but I just don't know whats wrong! I have imported for example climate data sets (they are huge) and making graphs out of them just does not work! I'm not sure how the data set should be arranged before trying to make graphs:/
@justabrotherfromphil Жыл бұрын
This was great but How do I resize the the chart border without donut and text box automatically resizing? My chart are too far apart because I have so much empty space between the border and the doughnut. But when I resize the height and the width of the border to reduce the empty space , the doughnut gets smaller too.
@terrianderson2039 Жыл бұрын
I need a chart for patient satisfaction survey results by term (20+ questions), then by question for the year, then by question year to year for a 5-year period.
@mohammedelsakally5409 ай бұрын
After two years of releasing this video i'm really so much appreciated the knowledge you always providing to your followers... thank you Jon.
@ExcelCampus9 ай бұрын
Great to hear that. 😀
@ulfmalmquist91623 жыл бұрын
Hi, thank you for the beautiful video, I'm interested in Donut Progress Chart. Greetings from Stockholm
@diannedrechsler47923 жыл бұрын
Wow Jon, these charts are incredible! Can't wait to try some of them out.
@RonaldC-s1s7 ай бұрын
Annual Trend with Monthly Details - is there a separate tutorial on this? Thanks
@kalpvyas47802 жыл бұрын
Hi, can i have this entire excel on the drive to practice... That would be a great help if possible..
@YouExcelTutorials3 жыл бұрын
Awesome stuff Jon! Thanks for sharing.
@GrainneDuggan_Excel3 жыл бұрын
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
@ExcelCampus3 жыл бұрын
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/
@ExcelCampus3 жыл бұрын
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_Excel3 жыл бұрын
@@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.
@sbutinaful3 жыл бұрын
Hi I am interested in forcasting, predictive analysis, and by the way thisnis amazing.
@John-tw6dc2 жыл бұрын
Thank you so much! this is very educational and helpful.
@successcoachingclasses4156 Жыл бұрын
which mic for noise cancellation you use?
@carmelitamartin11573 жыл бұрын
Can you please create a dynamic chart for a weekly sales comparison against last year sales on a weekly basis as well
@ramdashwant20243 жыл бұрын
Very beautifully explained 💗🎊💖❤️😘
@Darshanam-Jatra3 жыл бұрын
Speaking figures, thanks Mr.Jon for sharing this amazing ideas
@lisaamante53843 жыл бұрын
Las Vegas, NV, USA: These are so very awesome!! Thank you so much!
@geetanjaliapte45312 жыл бұрын
Can you pls explain Waterfall presentation. Thnx
@conradhaynes46722 жыл бұрын
Superb presentation. Thank you. I would be interested in graphs (box plot, normal and binomial distributions) linked to statistical data analysis / probability modelling.
@marcalleranthonyguevarra74593 жыл бұрын
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!
@judywilder78833 жыл бұрын
The Zoom on Chart macro would be great to implement in a report I am working on now!
@johedennyssantanamontero48583 жыл бұрын
Suscribed! Yes sir! This is awesome!!
@aidacurraj88043 жыл бұрын
Excellent explanation, thank you very much
@favourite22 Жыл бұрын
How to make stack charts which shall show the comparision
@ianmurdoch6315 Жыл бұрын
Do you have a tutorial for the interactive waterfall chart
@meliheser01 Жыл бұрын
3d stacked column pls
@lukev7303 жыл бұрын
Amazing ideas Thank You Jon
@chetnar4512 жыл бұрын
How to create a 2x2 heatmap in Excel please??
@darrylmorgan3 жыл бұрын
Cool Tutorial!! Great Explanation Of Data Type's And What Chart Is Best To Tell The Data Story...Thank You Jon :)