To make the pivot chart in the activity below, you must first have created a pivot table as described in my last post. Pivot charts are another way to analyze data about subgroups in a survey population. Make a table and a chart and consider which method you prefer to make conclusions about the survey results.
Follow the instructions to create a pivot chart.
- Open the spreadsheet with the responses that you created when making the pivot table.
- To view the pivot table, click the Pivot Table 1 tab at the bottom of the window.
The table should look something like this:
- Remove the Grand Totals:
- In the Rows area, remove the checkmark in the Show totals box.
- In the Columns area, remove the checkmark in the Show totals box.
- From the Insert menu, click Chart.
- On the Start tab, click Use row 1 as header to add labels to the legend. Click Insert.
- Click on the chart and drag it beside the pivot table.
- Label the chart:
- Click on Chart title. Type Comparison of X by Y. Press ENTER.
- Click on the Left vertical axis title. Type Description. Press ENTER.
- Click on the Horizontal axis title. Type Number of People. Press ENTER.
- Save the chart: (optional)
- Click the arrow on the top right corner of the chart.
- Select Save image.
- Do you prefer a pivot table or pivot chart when comparing data? Why?