How do I make a graph from a table?

How do I make a graph from a table?

Creating a graph from a table

1. Open the table that contains the data values to graph.
2. Click the Table Options button.
3. Click the Graph type drop-down arrow and choose the type of graph you want to create.
4. Click the Layer/Table drop-down arrow and choose the table as the source of the data values you want to graph.

How do I get Excel to show data in a graph?

On the Layout tab, in the Labels group, click Data Table. Do one of the following: To display a data table, click Show Data Table or Show Data Table with Legend Keys.

How do I add a table below a graph?

Work

1. Introduction.
2. 1Click anywhere on the chart you want to add a data table to.
3. 2On the Chart Tools Layout tab, click the Data Table button in the Labels group.
4. 3Make a selection from the Data Table menu.
5. 4Click OK.

How do I make a graph from an Excel spreadsheet?

Create a chart

1. Select the data for which you want to create a chart.
2. Click INSERT > Recommended Charts.
3. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.
4. When you find the chart you like, click it > OK.

How do you add a legend to an Excel spreadsheet?

Click the chart, and then click the Chart Design tab. Click Add Chart Element > Legend. To change the position of the legend, choose Right, Top, Left, or Bottom. To change the format of the legend, click More Legend Options, and then make the format changes that you want.

How do you create a comparison chart in Excel?

Making a Column chart

1. Select the data, including both series and headers (all three columns).
2. Click the Chart Wizard button on the Standard toolbar or choose Insert –> Chart.
3. Click the Next button twice.
4. Click the Titles tab.
5. Enter an appropriate title for the chart.
6. Click Finish.