A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is there any way to stop chart imagery from scaling randomly?



 
 
Thread Tools Display Modes
  #1  
Old October 21st, 2003, 06:56 PM
how_D
external usenet poster
 
Posts: n/a
Default Is there any way to stop chart imagery from scaling randomly?

Excel charts have this tendency to change size in a random way, an I need to
figure out how this can be prevented, either programmatically, or through
use of object options that I have somehow missed.

Example: Pie chart. Clicking on it to access some of the settings can, even
if nothing is changed, cause the pies to change their size, usually smaller.
This is especially true if some setting IS changed, and even more so if the
chart in question is accessed as an object placed within Word.

When I say "change size", I mean the imagery, not the size of the bounding
box containing the imagery.

The problem is worsened by the activity of grabbing one of the bounding box
corners and scaling the chart larger. Yes, the image grows, but after the
image is grown to the desired size, you cannot then reduce the size of the
bounding box without the image scaling down again, and it will be even
smaller then before. It is like a ratcheting effect.

Is there no way to specify or at least lock the size of the image,
independent of the box containing it? Is there no way to keep these things
from randomly changing their size?

My goal is to have two adjacent pie charts, comparing different data, but
coordinated in style, angle to viewer, 3D thickness, etc. Even if one pie
only has two pieces with labels and the other has six with labels, I want
the final product to show the overall pies to be the same physical size on
the page.

I also want them to print without reducing their size, and to come into Word
with the same smoothness of curves that they have when they are still in
Excel.

Is this too much to want???? Is there any definitive and affirmative
solutions to these problems?

Bill


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.