How To Make Graphs In Excel

Hi, my name is Ghamza Jacobs and I am an IT trainer with New Horizons in London. I am here today to show you couple of cool little tips and tricks on Windows 7 and Office 2010. How to make and modify graphs in Microsoft Excel? We are going to create a quick bar chart or bar graph within Microsoft Excel and use some of the nice bulletins features in Excel 2010 to modify very very easily.

First step, I am going to select my data, so I am selecting from B6 down to F10. This is essential, the data you select is going to be represented on the graph so if you select your column headings and your row labels, they are all going to be listed out over there. There is a very handy keyboard shortcut to create a chart or graph within Microsoft Excel.

If you selected your data, press F11. That automatically creates a chart on a new sheet, that was the keyboard shortcut F11 at the top of your keyboard. Now to modify the chart really easily, Microsoft Excel 2010 and 2007 bring up chart tools and this gives you three new tabs that you may not have seen before.

To modify the chart really easily, one can drop down chart styles. You can see I have got a drop down arrow over there and I can very easily choose from one of the very very nice bulletin color schemes. Going to go with that one, if I wanted to add your labels and the values at the top of the graph, there is a number of chart layouts on the side here that one can choose from.

Drop that down, select perhaps that layout and look, it's added my numbers nice and clearly at the top. If I ever decide, you know what I don't like this bar chart, I can easily change my chart type on the far left. This gives you all of the different chart types.

When you do manipulate or change the chart, please, it's quite important to select a chart type relevant to your data, don't you select because it looks cool. I have seen many people go, “Oh yeah, let's go for the surface chart, yeah, let's do that one.” What does it mean? “I don't know it looks great.

” So choose a chart type that's relevant to the type of data that you are representing, so the important thing here is that you get a clear easy to understand chart that graphically represents your data in an accurate fashion. That was how to create and easily modify a chart using Microsoft Excel.