| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to set a variable to a Chart? not ChartObject
Sheet1 contains "Chart 1"
I want to set a variable to "Chart 1" Dim chrt As Chart Set chrt = Sheets("Sheet1").ChartObjects("Chart 1") This gives a type mismatch error. If I Dim chrt As ChartObject then I do not get the chart methods/properties in the dropdown. But I don't see any other options for setting chrt to "Chart 1". Any suggestions appreciated. Thanks, Rich |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete old chartobject and create a new named one? | Charts and Charting in Excel | |||
| Selecting chartobject without index no. | Charts and Charting in Excel | |||
| ChartObject Name Restricion or Excel Bug | Excel Programming | |||
| Fill screen with chartobject by zooming? | Charts and Charting in Excel | |||
| ChartObject index | Excel Programming | |||
Threaded Mode
