Download the file I used in the video from here: pages.xelplus.com/economist-charts-file 👉 Join Business Charts in Excel course 👉 link.xelplus.com/yt-c-eco-bizcharts-course
Creating these awesome charts in Excel is great! But, I often find they lose their luster when I transfer to Word, especially tables. How can we successfully transfer tables, especially large ones, from Excel to word without having to reformat them to better fit the page?
Dear Ms. Gharani, Good day! I have a question. Is it possible in excel to view data using a drip down list, then edit that data? Example is: Student A has a quiz score of 5 for his first quiz, 10 for his second quiz, then let's say i mistakenly entered 10 but actually it was 9. I hope I said it correctly. English is not my first language. Hoping for a video tutorial reply. Thank you!
30 years as of Feb 1 that I'm using Excel at work. Again, again and again you're bringing new ways of doing things in professional manner and with smart ideas. Stunning. 👍😎
Honestly! The Economist for me is the THE best on creating charts, communicating lots of information in a compact way. I'm right now trying to change how we report end of q budgets and variances. This will come in handy.
@@LeilaGharani I kindly suggest also checking out graphics from The Financial Times + Five Thirty Eight + Washington Post + Wall Street Journal + New York Times....
I paused a couple of times and followed for the 1st chart; paused many times and followed for the 2nd chart; watched 3rd chart and appreciated how well it was done.. Good tutorial!
I looked at those Economist charts when I was in school and it does look professional and elegant. Thanks for showing how its done. Long live Aptos Narrow , unrolling the shame brought by Calibri
The method used for designing charts to those seen in The Economist impressed me greatly. These types of charts professionalism and simplicity that highlight the data without unnecessary decorations. The advice, on color selection and font choice was particularly helpful. Now I see how intricate data can be presented in a comprehensible way. I will incorporate these techniques into my projects! Thank you for the valuable insights! )
It’s really understated in college at every level how needed data visualization skills are across nearly all fields of work. I wish I learned more about excel tools in school and I’m working on my third graduate degree at this point with little to no excel skills taught outside of what I taught myself off RU-vid. And I’m in a STEM field.
Love it! This is one of my favorite ways to make horizontal dumbbells. One thing to mind is If your series have points of switching - blue dots lower and vice versa - I’ve found if you point the difference column to both pos and neg error bars this does the trick! 🎉
Leila - another GREAT video... but you make it look so easy, which means I will need to watch this like 50 times before I get it right! Thank you so much for posting this!
Leilani I have to congratulate you. It's been a LOOONG while since I last learned something entirely new in Excel. Your dumbell chart was exactly that, and I'm able to implement it basically as is in my recurrent reporting on a monthly basis. Love it. Props to you for a professional video and have my like.
Amazing as always! I've been using mostly Power BI now for visualization; however, I still keep on checking your channel for new videos/tutorials so I have tricks up my sleeve I can use just in case. 😀 Thank you, Leila! ⭐
Hi Leila! Today’s sponsor, Think-Cell, is a powerful tool. It would be great to see you showcasing some examples connecting Excel with Think-Cell for more systematic approaches… from number crunching to executive level presentations, just like the graphs you showed today. Thank you for your amazing content! You have certainly made my insights a lot better and nicer over these years. Warm regards!
One of the best videos I have recently watched. I wanted to make a lollypop chart but could never do it. Thanks to your simple style of teaching I did it.
That’s amazing what you showed us, ways to work with Excel to get really good looking visuals! Sometimes you don’t know whether you do this in Excel, or you do this in PowerPoint and add objects, etc to make it look nicer, which is a lot manual! Thanks for sharing Leila
Fantastic content, as always! Your videos never fail to impress me, and I particularly enjoyed this segment. Looking forward to seeing more content like this in the future. Keep up the great work!
I loved the lesson on charts Leila thank you. Can't wait for the business charts course. The Excel Visualization course in Udemy is one of my favorites. I go back to it all the time when I need to do some charting.
Thanks Leila I liked the first bar chart but really wanted the category labels automatically/dynamically added if new row(s) were added. My solution was similar to prior content from you, "Excel Clustered Column AND Stacked Combination Chart". The basic idea is to add an additional invisible series that displays the Category labels. Firstly, make the data a proper Table, then create the Bar Chart Copy and Paste the data values a second time to the chart, so there are 4 'segments". Set the original series on the secondary Axis, new series on the primary. Update the (reverse) order for both Primary and Secondary vertical axes. Set the secondary Series Overlap to -100% and Gap Width to 0% Add a label to the series/bar that has been split. Set the Label to show Category Name and position as Inside Base, also you turn off "Wrap text in shape". Change the Fill to No Fill for the secondary axis bars. Thats it, try adding a new row to the table. Hopefully, you'll see the bars and Category labels just add themselves.
Beautiful charts 😊 However, if the table source for the first chart gets a new category the text box approach would not be dynamic. Could you show us, how you would make that chart dynamic instead of using text boxes? Love your work btw!
I also wanted Chart 1 to be dynamic. Hoped I'd find a solution in the comments, but no solution found. So decided to solve for a dynamic Chart 1 and share my solution. Please find key steps in my comments above.
I would like to add that if you hold down Shift while clicking and dragging an object, it will lock movement to the orthogonal directions only. You can use this in combination with holding Ctrl as shown in the video (3:35) to make a copy of the object that is strictly aligned with the original, to keep them all in line. Alternatively, you can use the Align objects feature from the Shape Format ribbon tab.
This is superb, the way you explain is clear to understand and replicate, you have a gift, and it's been years since I've been following your work on RU-vid, and getting better at my job by applying all the knowledge you shared, thank you so much! Keep it up with this amazing work.
Xlookup with pictures? This is awesome. I need to try this asap. In the past I've used the camera tool in combination wit offset() but that makes the quality of the image worse somehow. Recently I've used Emojis because there is still no way to add your own icons in conditional formatting. This might be a game changer. Thanks for the tip! 😊
Thanks, just leaned new ways to manipulate cells in Excel, not that I’m going to manipulate any Excel cells anytime soon, the information does come in handy! 😊😺🥰👩💻⭐️💎
On the first chart, the thing that isn't being captured (though just a case of adding a border to the bars) is the thin white dividing line between the bars which is a nice style element of the original.
I'm always looking the content you put here Leila, it is a quality benchmark! however, I found that when you insert the text box while the plot is selected doesn't work with Histograms. I had to group them together to make it work. Cheers!
I downloaded the file but am struggling to replicate the stacked bar chart. I only need one row, but when I remove the four other rows, the chart inaccurately displays the data. For example, if I wanted only "battery cells" and made China 200 and US 40, the 40 bar section appears very long, as if it's representing 200.....and the 200 shows up small as if it's representing 40. This only happens after I remove the other 4 rows or change the chart select data to only the "battery cells" row. Not sure what could be causing this. Ideas?
Once again, an effortless presentation by Prof Leila of excellent content ... leaving me with lots of ideas to pursue ... a nice way to start the day. Thank you ... thank you ... thank you ... 😍😍😍
Another Excel-ent tutorial, thank you. I wonder, with the Dumbell chart, is there any way to get the difference values to show ON the error bars? I don't see a Data Labels option for the error bars.