| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting size
I have a problem when using a macro to set size of a chart. I acnnot use the
macro recorder so I want to be able to set size in code. My code is: Charts.Add ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:="Standard" ........ ActiveChart.Shapes.ChartArea.Height = 1000 As you may see the last line is faulty..I just dont know how to write it. What I want to do is to set the size (height and width) in the code. If you know how to solve this please help me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting Listbox Size VBA | Excel Worksheet Functions | |||
| getting size or setting it? | Excel Programming | |||
| Problem setting font size | Excel Programming | |||
| Setting size of icons | Excel Programming | |||
| setting a chart size | Excel Programming | |||
Threaded Mode
