Organizing data for pie graphs
You organize data for pie graphs similarly to other graphs. However, each row of data in the worksheet generates a separate graph: Pie graph data - Enter data-set labels as for column, stacked column, bar, stacked bar, line, area, and radar graphs. Enter category labels if you want to generate graph names. (See Setting up labels.)
- To create a single pie graph, plot only one row of data, either all positive or all negative values.
- To create multiple pie graphs, plot additional rows of data, either all positive or all negative values. By default, the size of the individual pie graphs is proportional to the total of each graph's data. For more information on changing the size of pie graphs, see Setting options for pie graphs.
|