Embedded Files
Creating Pie Charts
Creating Pie Charts
Pie Charts
Pie Charts
Pie charts are used to show relative proportions of the whole, for one data series only. Data series are a group of related data points. A data point is a piece of information that consists of a category and value.
For example, if you were collecting data on how customers heard of your business, then the number of customers who were "referred by a friend" would be a data point; the number of customers who "saw an online ad" for your business would be another data point. In this case the categories are "referred by a friend" and "saw an online ad" and the value for each category is the number of customers who heard of you business that way.
When you create a chart with Spreadsheets, the categories are plotted along the horizontal or X-axis, while the values are plotted along the vertical or Y-axis.
Data series originate from single worksheet rows or columns. Each data series in a chart is distinguished by a unique color or pattern. You can plot one or more data series in a chart except for pie charts.
An example of a data series is the population of the United States over ten years. Each data point would be made up of a year (the category) and the population in that year (the value).
There are four general steps in creating a chart.
Enter the numbers into a spreadsheet.
Select the data to be used in the chart.
Choose the type of chart you'd like to create from the chart options (pie, bar, etc.).
Use the chart tools for style and formatting (adding titles, colors, legend, etc.)
These four steps should be performed in this order. Note that since the chart is linked to the spreadsheet data, any subsequent changes made to the spreadsheet data are automatically reflected in the chart.
Creating a Pie Chart
Creating a Pie Chart
Do the following:
➤ Create a new spreadsheet called "Expenses".
➤ Enter the following data into your Expenses spreadsheet:
Cell A2: Food
Cell A3: Clothes
Cell A4: School Supplies
Cell A5: Bills
Cell A6: Gas
Cell A7: Recreation
Cell B1: Weekly
Cell B2: 75
Cell B3: 25
Cell B4: 10
Cell B5: 80
Cell B6: 50
Cell B7: 65
➤ Select the data that you just entered (cells A1:B7)
➤ Click the Insert option on the menu bar, and then select Chart.
A default suggested chart and the Chart editor will appear.
➤ From the Chart editor, click the Chart type dropdown menu and select the 3D pie chart option.
Customizing Chart Options
Customizing Chart Options
Do the following:
➤ Click the Customize tab in the Chart Editor, and expand the Chart & axis titles section
➤ In the Title text box type "Weekly Expenses"
➤ Expand the Legend section and change the Position to Bottom
➤ Expand the Pie chart section and change the Slice label to Percentage
You can also customize options by clicking directly on the chart.
➤ Click on a slice of the pie to select it. The Chart editor will display the Pie slice options. Change the color of one of the slices
Moving the Chart to a Separate Sheet
Moving the Chart to a Separate Sheet
Do the following:
➤ Click the Chart to select it.
A chart option icon will appear in the top right corner (indicated by three dots)
➤ Click the icon and select Move to own sheet
The chart will then appear in a separate tab in your Spreadsheet called Chart1
Note that you can also Download the chart as a separate image or document file.
In the final part of this tutorial you will create another type of chart called a Column Chart.
Page updated
Google Sites
Report abuse