preserve sizing of pivot chart buttons

J

jackie

I have a front end with 4 embedded pivot charts. Each chart has macros take
the user to select different categories, then go into the table of the pivot
report. However, when to do, the macro buttons are resized because the chart
changes and is resized. In addition, when they select a category, the chart
title pops up, and also moves the pivot table buttons.
I tried adding protection, but all that did is stop the macros from working.

Is there any way to maintain the button formatting when the pivot chart data
changes. Thanks.
 
S

ShaneDevenshire

Hi,

What version of Excel are you using? Are the buttons ones you have added or
field buttons? If your own buttons, where are they, on the chart or in the
spreadsheet? Also, you say the chart resizes? do you mean the plot area
resizes?
 

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

Remove series from pivot chart 1
Arrange columns (lo - hi) in a Pivot Chart bar graph. 2
Preserve formatting in Pivot Chart 1
Odd Excel 2007 behavior: copied chart linked to source sheet 4
excel2007 pivot table chart x-axis 1
Excel 2007 Pivot charts, any way to display filters on the chart? 1
Create separate pivot chart for each filter 3
Pivot Chart with 2 horizontal axis field (categories) 1

Top