Charts in closed groups shrinking

R

rtilghman

Having a wierd problem with charts - pie charts specifically - I've
included in collapsible groups in a spreadsheet I use to do analysis.
Hoping someone here can help.

Basically I'm finding that if I size a pie chart that's in a
collapsible group (row group), collapse that group, save the XLS, then
uncollapse the group the pie chart is approximately half its size. If
I do it again the chart is half again its original size.

Does anyone know what's going on? Is there a way to make sure Excel
preserves set chart sizes? I can't find any setting around this, and
its annoying to either keep all my groups open (they're grouped so I
don't have to see them all at once) or resize the pie charts
repeatedly (I have a lot of them).

Thanks in advance for any help.

-rt
 
R

rtilghman

Having a wierd problem with charts - pie charts specifically - I've
included in collapsible groups in a spreadsheet I use to do analysis.
Hoping someone here can help.

Basically I'm finding that if I size a pie chart that's in a
collapsible group (row group), collapse that group, save the XLS, then
uncollapse the group the pie chart is approximately half its size. If
I do it again the chart is half again its original size.

Does anyone know what's going on? Is there a way to make sure Excel
preserves set chart sizes? I can't find any setting around this, and
its annoying to either keep all my groups open (they're grouped so I
don't have to see them all at once) or resize the pie charts
repeatedly (I have a lot of them).

Thanks in advance for any help.

-rt


Anyone have an idea on this?
 

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

Top