How to Make a Chart in Excel

Configurare noua (How To)

Situatie

Once you input your data and select the cell range, you’re ready to choose your chart type to display your data. In this example, we’ll create a clustered column chart from the data we used in the previous section.

Solutie

Pasi de urmat

Select Chart Type

Once your data is highlighted in the Workbook, click the Insert tab on the top banner. About halfway across the toolbar is a section with several chart options. Excel provides Recommended Charts based on popularity, but you can click any of the dropdown menus to select a different template.

Create Your Chart

  1. From the Insert tab, click the column chart icon and select Clustered Column.

How to select Excel chart

  1. Excel will automatically create a clustered chart column from your selected data. The chart will appear in the center of your workbook.
  2. To name your chart, double click the Chart Title text in the chart and type a title. We’ll call this chart “Product Profit 2013 – 2017.”

Tip solutie

Permanent

Voteaza

(6 din 9 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?