Excel Basic Graph Tutorial

A step by step excel chart tutorial 1.

Excel basic graph tutorial. 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. Get your data ready. To move the legend to the right side of the chart execute the following steps.

Select a graph format. Learn the basics of excel charts to be able to quickly create graphs for your excel reports. 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. How to build an excel chart.

Click the chart type from the charts section of the ribbon see image. Select the data to include on the chart. 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. Include any cells that contain text labels that should be in the chart too.

Click the button on the right side of the chart click the arrow next to legend and click right. The sub type menu displays. Charts allow your audience to see the meaning behind the numbers and they make showing comparisons and trends much easier. A chart is a tool you can use in excel to communicate data graphically.

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 templates. Excel offers various chart types each suited for a different type of data analysis. You can use data labels to focus your readers attention on a single data series or data point. In this tutorial you will learn how to insert charts and modify them so they communicate information effectively.