Share via

The PivotChart button doesn't work. It isn't grayed out; when I mouse over it the button highlights but when I click on it nothing happens.

Anonymous
2011-11-06T16:53:51+00:00

I'm trying to create a PivotChart from a PivotTable

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

triptotokyo-5840 36,686 Reputation points Volunteer Moderator
2011-11-06T18:57:08+00:00

EXCEL 2007

Are you clicking in the underlying data then:-

Insert tab.

Tables group.

Click on the drop down arrow beneath:-

PivotTable

 - then click on:-

PivotChart

The Create PivotTable with PivotChart window should open.

Click:-

OK

(if you are happy with the Table/Range: setting).

The PivotTable Field List should now appear on the right hand side.

Select the fields you want to appear on the chart.

If my comments have assisted please vote as helpful.

Thanks.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest