Microsoft Excel Tutorial Making Graphs

Thats where charts come in handy.

Microsoft excel tutorial making graphs. Microsoft graph tutorials are step by step training exercises that guide you through creating a basic application that accesses data via the microsoft graph. Excel makes it easy to swap out the type of chart youre usingeven after its created. Excel spreadsheets are all about numbers. If you want to learn about excel charts youve come to the right place.

Select data for the chart. To do so click within the chart go to the chart design tab find the change chart type button and select the type of chart you want to swap to. Create a chart in excel 2007 2010 2013 and newer versions note. Select a chart on the recommended charts tab to preview the chart.

5 type in a title for the spreadsheetgraph using the first rows. Learn the basics of excel charts to be able to quickly create graphs for your excel reports. Click the insert tab. Add a title to the graph.

In the new versions of excel hover the cursor over a chart type or sub type on the insert ribbon to display a description of the chart. In this beginning level excel tutorial learn how to make quick and simple excel charts that show off your data in attractive and understandable ways. You can select the data you want in the chart and press alt f1 to create a chart immediately but it might not be the best chart for the data. To enter a formula in excel you highlight data in a row or column.

Click the button on the right side of the chart click the arrow next to legend and click right. Charts can display numeric data in a graphical format making it easy to understand large quantities of data and the relationships among data. On a mac youll instead click the design tab click add chart element select chart title click a location and type in the graphs title. Click the chart type from the charts section of the ribbon see image.

Select insert recommended charts. Double click the chart title text at the top of the chart then delete the chart title text replace it with your own and click a blank space on the graph. To move the legend to the right side of the chart execute the following steps.