How to make a graph in excel

how to make a graph in excel

In this video tutorial, you’ll see how to create a simple line graph in Excel. Using a graph is a great way to present your data in an effective, visual way. Excel offers many different chart. How to make a line graph in Excel. Line graphs, also referred to as line charts, are used for plotting a data series (or several) against category values to display trends. Keep in mind: These graphs are commonly confused with XY (Scatter) charts, which, unlike line graphs, have no category values. Enter your graph's data. Starting in the cell immediately below your first header and immediately to the right of your first label (most likely B2), enter the numbers that you want to use for your graph. You can press the Tab ↹ key once you're done typing in one cell to enter the data and jump one cell to the right if you're filling in multiple cells in a row. How to Make a Graph in Excel. Enter your data into Excel. Choose one of nine graph and chart options to make. Highlight your data and 'Insert' your desired graph. Switch the data on each axis, if necessary. Adjust your data's layout and colors. Change the size of your chart's legend and axis labels. Change the Y axis measurement options, if. After you create a chart, you might want to change the way that table rows and columns are plotted in the chart. For example, your first version of a chart might plot the rows of data from the table on the chart's vertical (value) axis, and the columns of data on the horizontal (category) axis. How to Make a Bar Graph in Excel. This wikiHow teaches you how to make a visual representation of your data in Microsoft Excel using a bar graph. Open Microsoft Excel. It resembles a white X on a green background. Scatter charts and line charts look very similar, especially when a scatter chart is displayed with connecting lines. However, the way each of these chart types plots data along the horizontal axis (also known as the x-axis) and the vertical axis (also known as the y-axis) is very different. How to make a graph in Excel. 1. Choose the right type of graph for your data. Excel offers nine different options including bar graphs, line graphs, pie graphs, and more. In this tutorial we will guide you to learn how to create a graph in Excel in few simple steps. Step 1 -- Create a Data Table In the first step, open Microsoft Excel Sheet and create a data table. How to Make a Graph in Excel 1. Fill the Excel Sheet with Your Data & Assign the Right Data Types. The first step is to actually populate an Excel spreadsheet with the data that you need. If you have imported this data from a different software, then it’s probably been compiled in a.csv (comma separated values) formatted document.