Ask Your Question

how to hide field buttons in pivot chart

asked 2017-10-25 16:43:42 +0200

gewaaid gravatar image

updated 2018-09-05 11:34:08 +0200

I was wondering how to hide field buttons in a pivot chart; Version: I cant export a diagram without the field buttons. Version: Still not possible, see link for explanation

edit retag flag offensive close merge delete


This question is a bit vague. Are you talking about the row and column sort/filter buttons? Those don't show up in PDF export...

KH gravatar imageKH ( 2017-11-03 02:19:53 +0200 )edit

See the pivot charts on Tomaz's dev blog. It has been a lot of effort to make these field buttons work. But how to hide them?

gewaaid gravatar imagegewaaid ( 2017-12-13 03:07:41 +0200 )edit

Ah, sorry, I see the problem now. The buttons on the pivot table disappear, but the ones on the chart don't. That's unfortunate.

KH gravatar imageKH ( 2018-09-04 01:06:08 +0200 )edit

BTW, I think your link illustrating the feature in MSO should be added to your question, not provided as an answer (because it isn't).

KH gravatar imageKH ( 2018-09-04 01:08:06 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-08-29 17:03:45 +0200

gewaaid gravatar image

updated 2018-12-07 11:17:10 +0200

Version: Still not possible, see link for explanation

Version: Still not possible, but I found a work around. To simply copy and paste the chart solves the problem. The new chart seems to be a normal ole object and also contains a data table. This makes it possible to do adjustments to the legend and even to the internal data table which no longer is associated with the pivot. And it does not contain the field buttons!

If a chart is directly generated form within the pivot table, the legend cannot be adjusted and there is no access to the internal data table. The reason for this is quite simple; the field buttons rely on the pivot table and this imposes restrictions. Once copied this is no longer the case.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-10-25 16:43:42 +0200

Seen: 428 times

Last updated: Dec 07 '18