Excel Graphs Tutorial

In this tutorial you will learn how to insert charts and modify them so they communicate information effectively.

Excel graphs tutorial. Get your data ready. Creating a graph in excel is easy. How to build an excel chart. You will be able to analyze the data more efficiently by looking at a graph in excel rather than numbers in a dataset.

Enter your data into excel. Create the basic excel graph with the columns selected visit the insert tab and choose the option 2d line graph. Highlight your data and insert your desired graph. Switch the data on each axis if necessary.

You will immediately see a graph appear below your data values. A step by step excel chart tutorial 1. Learn the basics of excel charts to be able to quickly create graphs for your excel reports. You can use data labels to focus your readers attention on a single data series or data point.

A chart is a tool you can use in excel to communicate data graphically. Before she dives right in with creating her chart lucy should take some time to scroll through her data and fix any errors that she spotswhether its a digit that looks off a month spelled incorrectly or something else. This tutorial covers all the basics including 1 getting to know the elements of a chart 2 modifying a basic chart to meet your needs 3 applying a predefined chart layout and chart style for a professional look 4 adding eye catching formatting to a chart and 5 reusing charts by creating chart. Click the button on the right side of the chart click the arrow next to legend and click right.

In this video i show you how to make a line graph in excel. To move the legend to the right side of the chart execute the following steps. Choose one of nine graph and chart options to make. 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.

Add a title to the graph. 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. Charts allow your audience to see the meaning behind the numbers and they make showing comparisons and trends much easier. In simple terms a graph is a visual element that represents data in a worksheet.

Sometimes if you do not assign the right data type to your columns in the first step the graph may not show in a way that you want it to.