| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Size & Position
Excel 97 macro copies data blocks to a sheet and plots a graph. This
works well but the size and position is somwhat random. I would like it to appear below the data array and be about the same size. Can that be done? Charts.Add ActiveChart.ChartType = xlSurface ActiveChart.SetSourceData Source:=Sheets("Test").Range("E" & MapPasteTo + 27 & ":Q" & MapPasteTo + 39), _ PlotBy:=xlColumns ActiveChart.Location Whe=xlLocationAsObject, Name:="Test" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fix size and position of comment | Excel Discussion (Misc queries) | |||
| Window Position & Size | Excel Discussion (Misc queries) | |||
| ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
| Chart size/position | Excel Programming | |||
| Position/Size a MessageBow | Excel Programming | |||
Threaded Mode
