Hi everyone this is Nick and today I'm going to show you how to make this kind of fun. Infographic curved column chart in Excel. Now I saw this in a video by Leila Gerani over on YouTube, and I'm going to put her link down below. I hope that you go and follow her. She and her channel are a wealth of information about Excel, PowerPoint, anything Microsoft really, so I hope you go and check her out. Subscribe to her channel. Subscribe to my channel too, but I wanted to see if I could make the same kind of curved bar chart effect. This infographic you feel with some of the data that I usually work with, which is. Really, things like visitor experience or visitor satisfaction. Survey data from informal learning places like museums, zoos, aquariums, that sort of thing so you can see right here. This is what the chart is going to look like, and that's kind of cool. It's just a different effect from the average every day. A column chart that we're so used to making, so let's flip over to the screen and I'm going to go ahead and make this. From scratch and we're going to do a few different techniques to get it to look exactly like this, so stay tuned. OK, so the first thing that we want to do is insert our column chart so we already know how to do that. This is my scores and it's going to be scores each month and so we're just going to go to the insert tab, go to the column chart 2D clustered column and so we would do all of the different editing tweaks. So this this would be where our. Title would be. Just title it this this year. Let's go ahead and update the font just a little bit. And then what I'm going to do is I'm going to reduce the gap width between the bars. I'm going to do that to 50%. That's usually what I like. 50 to 30%. We're going to go ahead and get rid of the grid lines. I don't think we really need those, and I'm just going to go and update the access to. 100 so just put a one there and that's going to be my Max right there. It looks like a nice com chart. I also want to get rid of this Gray border around my chart, so I'm going to go ahead and say no border. Now this is a really nice column chart. If we wanted to we could put labels in there and that would be nice too. We could put labels outside the columns. Now if I want it to be curved, all we need to do is embed a picture or an object into these columns and we can do that right inside of Excel. Go to the insert tab and then the shapes and then I scroll. All the way down here to sort of this half it's called flow chart delay, but it's sort of like a kind of 1/2 circle or Half Moon, so I'm going to click that and then I'm just going to go ahead and I'm just going to draw it. Here on my side here perfect and I'm going to format this. I'm going to keep it the same blue color, but I'm going to make sure that it's set to no outline, so that's a really important step in this process is make sure that the shape is no outline, and then what we're going to do is we're just. Going to rotate it that 45 degrees there. So it's right there perfect. All right now all I need to do you can move this to wherever you want to do it. I'm just going to push central C or I'm going to right click and click copy and I'm just going to click the bars and I'm going to paste so right click and paste. Oops, I guess right click doesn't work for me to paste here. Uh, I think maybe I could just click this perfect. I just click the paste button up there. You could do control C and then control V. For paste So OK, this looks kind of interesting, but you can see that the the curves are really stretched and so this might be the look that you like, but I want to do it so that it looks a little bit different than that. So what we're going to do? Is I'm actually going to go down here and we're going to make a new chart. First, we're going to make a we're actually going to make the chart into a stacked column chart, so I need to rework with the source data a little bit. We can't just insert a chart from the source data that we did before. I have to create a couple of variables here. So the first thing I'm going to do here. This is kind of just up to your taste, but I'm going to do. A formula here. So it's going to be equals the score minus .1, so that's minus 10%. So everything here is going to be 10% lower than the actual value of my score. I'm just going to go ahead and format it to 0 decimal points and then here. What I'm going to do is I'm just going to have 10% in this column like all of these. Cells are going to be 10%, right? Now this is going to form the base of my stacked column chart. So what I'm going to do now to insert that column chart is highlight this, push the control key, and then I'm going to highlight the lower and upper stacks. Here I'm going to keep the score the actual score out of this. For now, we're going to go up to insert, and we're going to go to the column chart tab here, and we're going to do. The center option here stacked column you don't want 100% stacked column. We just want the normal stacked column right here. Alright, so now you might be able to see where we're going here. We can go ahead and do whatever you want to with the formatting of the chart. I'm going to get rid of that border again. I'm going to get rid of the gridlines. I'm going to update the axis here. 100 and let's do that gap width to 50 again 50% perfect alright, and I'm going to go back up here. I still have this copied. I'm going to go ahead and right click, copy the kind of the Half Moon object and then right in the top stack of the chart I'm going to push control V to paste and you can see now. It stretches less because there's just less space there, so the actual shape doesn't stretch so much, and so the curves on the top are much broader, and I think I like that look a lot better. I'm going to go ahead and get rid of the legend, because that's meaningless to us. Right now the other thing here is you might want to put in labels so I could put in data labels to this top section, and then I'm going to update the color. But you can see it's all 10%, and that's not right, because that's just pulling from the created variables or the created chart data source that we made. So now with all the data labels selected, all you need to do is go over to the little format data label menu, click on the bar chart and instead of value. Go up here and save values from cells and now this is where we need to use our actual score. So now we're going to point to the data that we want to put into those labels, and I'm just going to go ahead and drag this into our score label here. We'll say OK, and now you see we have a perfect bar chart with the curved tops. And the correct data labels on the end of the columns. So again, thank you so much. Leila Garani for showing me this technique I'm definitely going to use it in some of my dashboarding and reporting. It's kind of just a fun, engaging way to make a column chart. Maybe you know a little bit less expected for your audio. If you like this video, I hope you give it a thumbs up and make sure to hit the subscribe button and the bell next to it. You'll get notified every time I post a new tutorial and data design, PowerPoint, Excel or word. Remember, you don't need to be a professional designer to look like 1. Using the software that you already have, and access every single day. I hope you have a great day and. I will see you next time.