How To Make A Line Graph In Excel
Ghamza Jacobs, an I.T. trainer with New Horizons, shows you how to make a line graph in both Microsoft Excel 2007 and 2010.
Hi, my name is Ghamza Jacobs, I'm an I.T. trainer with New Horizons in London.
I'm here today just to show you a couple of cool little tips and tricks on Windows 7 and Office 2010. How to create a line graph in Microsoft Excel? When creating graphs in Microsoft Excel, in 2007 or 2010, the easiest way to work with this, is to select your data first. So what I'm going to do right here is select my months, sales and expenses data.
Within the newer versions of Excel, your graphs or charts are available under insert, so the Insert Tab right at the top, you've got a charts group right over here, and you can see I can go directly to the chart type I want, the one we're going to look at right now is a line chart so all I do is go straight to line and it even asks you “what type of line chart would you like.” I can go in and say OK, I'll go for the stack line, why not, click on to that, the line chart gets created, obviously pretty basic one this is. But after you've created the line chart, Excel 2007 and 2010 both open up chart tools at the top, now you can very easily, under design, change the colors, selecting one of the built in ones, let's say you decide you want this particular chart to be on this sheet because notice what has happened, it places the chart onto the same sheet as your data, you simply would like to move the chart, one can easily just off the design, move chart, create it in new sheet so that will take it to a sheet or page of its own, OK, and now I have a chart created on a new chart sheet.
That was how to create a basic line chart in Microsoft excel.