Unfortunately, there is no way to control the size of Excel graphs other than with the mouse. Even Visual Basic for Applications (which allows almost total programmatic control of an Excel workbook) does not permit this. Through VBA, you can control almost every aspect of a graph, including title, labels, tick marks, etc., but not the size. It seems that Excel reserves the size to itself, so that it can "optimally" position the graph within the frame.
> ---------- > From: Rudolf Hooijenga > Sent: Wednesday, September 1, 1999 4:43 PM > To: Sundial List > Subject: Setting X-Y sizes of Excel plots > > Dear All On The List, > > In Microsoft's Excel I can easily plot X-Y pairs, so that I can lay out, > for example, an analemmic dial. > By fiddling with the mouse I can stretch the graph until it looks about > right. See attachement (5 kB, hope that's ok). > > It would be nice, though, if I could just input the wanted sizes in > centimeters (or inches), just like you can for a figure in Word for > instance. > > What does work is this: I copy the graph, then paste it in Word, then > choose Edit Figure and just input the wanted sizes. It will then print > fairly squarish (if it should be square..) > I cannot find such an input possibility in Excel itself. Am I overlooking > something? > > If I'm not, I'll just import in Word, no problem. Just curious. > Thank you for bearing with me! > Kind regards, > > Ruud > [EMAIL PROTECTED] > [EMAIL PROTECTED] >
