Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 5th 07, 09:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 19
Default Charts in closed groups shrinking


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


  #2   Report Post  
Old March 7th 07, 01:18 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 19
Default Charts in closed groups shrinking

On Mar 5, 3:04 pm, wrote:
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel File is shrinking two pages to fit to one page ChuckW Excel Discussion (Misc queries) 1 December 13th 06 04:52 AM
Shrinking Checkbox and Radio Button Dennis C BroadWare Excel Discussion (Misc queries) 0 November 10th 06 04:01 PM
HOW DO I KEEP DATA (SPREADSHEET EXCEL) FROM SHRINKING WHEN SAVED? DINGY Excel Discussion (Misc queries) 0 October 10th 06 05:47 AM
Shrinking Charts Neil Charts and Charting in Excel 0 February 14th 05 07:29 PM
how do i view all groups under excel in google groups JulieD Excel Discussion (Misc queries) 2 December 16th 04 05:33 PM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017