Graphs with excel tutorial. A step by step excel chart tutorial 1. In this video i show you how to make a line graph in excel. Select a graph format. Excel covers a wide range of graphs that you can use to represent your data.
In this tutorial you will learn how to insert charts and modify them so they communicate information effectively. Charts allow your audience to see the meaning behind the numbers and they make showing comparisons and trends much easier. To move the legend to the right side of the chart execute the following steps. Its a really simple process and you can turn any data into a nice looking line graph.
You will be able to analyze the data more efficiently by looking at a graph in excel rather than numbers in a dataset. About the tutorial a chart is a tool you can use in excel to communicate data graphically. The graph will be created in your document. In your selected graphs drop down menu click a version of the graph eg 3d that you want to use in your excel document.
In this video of this free online excel training i will show you how to use some tricks to create advanced charts and graphs in excel. How to build an excel chart. Get your data ready. In simple terms a graph is a visual element that represents data in a worksheet.
Click the button on the right side of the chart click the arrow next to legend and click right.