Pivot Chart - how to hide buttons?

R

RADO

I have a pivot table and an associated pivot chart. I want user to see all
fields in the table, but I don't want them to be visible on the chart. If I
try to remove them, the layout of the pivot table is screwed. Is there any
way to hide the buttons on the chart without affecting the pivot table
layout?

Thanks -
RADO
 
N

nigelab

Try right clicking the object on the chart. You should be able to
select hide. Dont ask me how you get them back though!

Regards, Nigel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Change report firlds in pivot tables and charts with one selection 0
Using VBA to create charts 1
create a pivot table and chart from a named range 1
Move Chart with Text 0
Excel does not accept text format! 0
Pivot Table Management 4

Top