Welcome to the Braintek video tutorials. My name’s Greg, owner of Braintek, and today, I’m going to show you how to do a bar graph in Excel.
So first, let’s open up Excel. Alright, so we’ve got Excel here, so now what we’re going to do is we’re just going to come up with some arbitrary data that we can throw into an Excel sheet. So we’re going to start with [row: 2013 2014 2015 2016] [column: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total].
Alright, so now we’re going to make a nice little grid out of all of this stuff so it’s easy for us to read. We’re going to total out our columns by creating a sum. Alright, so we’ve got some data here, you can see the totals going on so now we’re going to create a bar graph. So we’re going to come over here to ‘Insert’ and we’re going to pick this very first one and we’re going to pick a bar graph. I’ll move it over here for you. Alright, so here, we’re going to select data.
Under the ‘Chart data range:’ we’re going to click on this button and we’re going to choose the totals that we’re going to want to display. So after you click on this, you can just click and drag and it will highlight all of those cells. Hit ‘Enter.’ As you can see here, it automatically started to fill it in, but it’s got “1, 2, 3, 4” which we don’t like that. So under ‘Horizontal access labels,’ we’re going to click ‘Edit.’
We’re going to click this little button and it’s going to do that same thing so we’re going to click and drag our titles and ow it’s got 13-16. If you want, you can right click and do ‘Add Data Labels’ and it will put the totals on top of the chart. We can rename the chart. We’re going to call this “Sales Data” and save that off. Now you’ve got a new little bar chart in your Excel document and you can show off your Excel skills.
I’d like to thank you for watching the Braintek video tutorials. Check out our other videos on the Braintek channel. Have a great day! Become a Subscriber!!