How To Create A Pie Chart

Table of contents:

How To Create A Pie Chart
How To Create A Pie Chart

Video: How To Create A Pie Chart

Video: How To Create A Pie Chart
Video: How to Make a Pie Chart in Excel 2024, December
Anonim

The spreadsheet editor Microsoft Office Excel is a good choice for graphical presentation of data from tables in the form of charts. Including there is also a pie chart with a lot of customizable parameters.

How to create a pie chart
How to create a pie chart

It is necessary

Microsoft Office Excel 2007 Spreadsheet Editor

Instructions

Step 1

Highlight the data to display in a pie chart. It must be a range of cells in the same row (or column) that has no negative or zero values. Microsoft recommends that the number of cells be seven or less. You can select two rows (columns) if the first of them contains titles (sector names) for the future diagram.

Step 2

In the menu, go to the "Insert" tab and in the "Charts" section, click the "Pie" button. A list with design options will drop down - select the one you need.

Step 3

As a result, Excel will create a pie chart from the table data you specified and enable its editing mode. Three more will be added to the existing menu tabs - "Design" (this tab is enabled by default), "Layout" and "Format".

Step 4

On the Design tab, you can click the Quick Layout drop-down list and select one of the predefined chart layouts. In the "Data" section, it is possible to change both the cells that serve as sources of data for displaying in the chart, and the cells containing the titles for the "legend" of the chart. In the "Type" section, you can replace the pie chart with any other type, or save the current design for later use as another template. The button in the "Arrangement" section allows you to move the chart to another sheet or to another area of the table. Within one sheet, the diagram can be moved with the mouse.

Step 5

The "Layout" and "Format" tabs contain tools for fine-tuning all elements of the chart design. In addition, by clicking on any of the segments of the finished diagram, you can separate it from the main circle by dragging it with the mouse to the desired distance.

Recommended: