Scribd
Upload
4 views2 pages

Create Excel Pivot Chart with Values

Creating a PivotChart with actual values instead of percentages in Excel involves several steps: 1) preparing the data in a table format with clear column headings like "Service Type" and "Count", 2) inserting a PivotTable and selecting the data range, 3) setting up the PivotTable by dragging fields to the Rows and Values areas, 4) choosing a chart type like a column or bar chart, 5) adjusting the chart to show values by adding data labels, and 6) customizing the PivotChart using design options.

Uploaded by

newchatg01
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

Create Excel Pivot Chart with Values

Creating a PivotChart with actual values instead of percentages in Excel involves several steps: 1) preparing the data in a table format with clear column headings like "Service Type" and "Count", 2) inserting a PivotTable and selecting the data range, 3) setting up the PivotTable by dragging fields to the Rows and Values areas, 4) choosing a chart type like a column or bar chart, 5) adjusting the chart to show values by adding data labels, and 6) customizing the PivotChart using design options.

Uploaded by

newchatg01
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Creating a Pivot Chart with actual values (counts, sums, etc.

) instead of percentages in Excel involves


several steps. I'll guide you through the process using a simplified example, based on the generic
data you provided:

1. **Prepare Your Data**:

- Ensure your data is in a table format with clear column headings. For your case, the columns
might be "Service Type" and "Count".

2. **Insert a PivotTable**:

- Go to the "Insert" tab on the Ribbon.

- Click on "PivotTable" and then select "PivotChart".

- Excel will ask you to select the data range for the PivotTable and the PivotChart. Select your entire
dataset.

- Choose where you want the PivotTable and PivotChart to be placed (new worksheet or existing
worksheet).

3. **Setting Up Your PivotTable**:

- In the PivotTable Field List, drag the "Service Type" field to the Rows area.

- Drag the "Count" field (or however your column is named that contains the numbers like 170, 14,
124) to the Values area. By default, Excel sums up the values if they are numerical.

4. **Choose Your Chart Type**:

- By now, you should see a default PivotChart created along with your PivotTable. If the chart does
not automatically show the values as you desire, you can change the chart type and settings.

- Click on your PivotChart to activate it.

- Go to the "PivotChart Tools" on the Ribbon, which appears when you select the chart. Under the
"Design" tab, you can find "Change Chart Type". Click on it.

- Choose the chart type that best fits your presentation needs. Column or Bar charts are often used
for this kind of data.

5. **Adjusting the Chart to Show Values**:

- If your PivotChart is not showing the actual values by default, you can add them manually.

- Click on the chart to select it.

- Right-click on one of the columns/bars in the chart.


- Select "Add Data Labels". This action will place the count numbers on your chart directly.

- If the data labels are not positioned as you like, you can right-click them again for more options,
such as "Format Data Labels", where you can adjust the label position, number format, etc.

6. **Customizing Your PivotChart**:

- Use the chart design and formatting options in Excel to customize the appearance of your
PivotChart. You can adjust colors, add titles, modify the axis, etc.

This process will help you create a PivotChart in Excel that displays the actual counts or sums of your
data instead of percentages. Remember, the key is to ensure your data is structured correctly from
the beginning and to familiarize yourself with the PivotTable and PivotChart tools for customization.

You might also like