How to control graph area

[Buddy]

Still running stone age version of excel (97).
Att least in this version it is very difficult to control
the size of the diagram area when you cetreate a graph
with the diagram tool.
This problem is dual. On the one hand there is no
entry/input (that I can find) to specify an EXACT diagram
area (in pixels, cm etc. On the other hand if you use the
drawing to to create the exact borders of the desired area
and then adjust the diagram (the coordinate system)
acrodingly - the d' thing won't remain stable.

Now is ther anyone out there how knows what to do. A
hidden surface entry for the desired area ? A macro to
control it that you would be prepared to share.

Looking forward to some bright idea, that might help me
overcamoe this shortcoming in excel.

Yours truly
So and so

 

[Debra Dalgleish]

Jon Peltier has some chart creation code that lets you specify where the
chart should be drawn:


http://www.geocities.com/jonpeltier/Excel/Charts/InteractiveChartCreation.html