How to Chart Data in Excel

Configurare noua (How To)

Situatie

To generate a chart or graph in Excel, you must first provide Excel with data to pull from. In this section, we’ll show you how to chart data in Excel 2016.

Solutie

Pasi de urmat

Enter Data into a Worksheet

  1. Open Excel and select New Workbook.
  2. Enter the data you want to use to create a graph or chart. In this example, we’re comparing the profit of five different products from 2013 to 2017. Be sure to include labels for your columns and rows. Doing so enables you to translate the data into a chart or graph with clear axis labels. You can download this sample data below.

Select Range to Create Chart or Graph from Workbook Data

  1. Highlight the cells that contain the data you want to use in your graph by clicking and dragging your mouse across the cells.
  2. Your cell range will now be highlighted in gray and you can select a chart type.

Tip solutie

Permanent

Voteaza

(8 din 19 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?