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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to control graph area
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 |
#2
|
|||
|
|||
How to control graph area
Jon Peltier has some chart creation code that lets you specify where the
chart should be drawn: http://www.geocities.com/jonpeltier/...tCreation.html Buddy wrote: 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 Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|