Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change chart properties.
Suppose you insert 2 charts "non programmatically" in an Excel worksheet (click InsertColumnStacked Colum for example). How would you change the chart properties programmatically? I've used the shapes collection, but that only worked for me with one chart. The problem is that I don't know how to differentiate between multiple charts. Is there some way to name the chart or shape somehow? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change chart properties.
For all this type of action try recording a macro which selects your chart,
then changes the relevant properties. "cr113" wrote: Suppose you insert 2 charts "non programmatically" in an Excel worksheet (click InsertColumnStacked Colum for example). How would you change the chart properties programmatically? I've used the shapes collection, but that only worked for me with one chart. The problem is that I don't know how to differentiate between multiple charts. Is there some way to name the chart or shape somehow? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Chart Properties for Multiple Chart Shts using a Worksheet | Charts and Charting in Excel | |||
Change PDF properties | Excel Programming | |||
Change graphic chart properties | Excel Discussion (Misc queries) | |||
change properties on | Excel Programming | |||
How to change chart properties given command from cell | Excel Programming |