| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can not figure out the code for the chart layout type I want
I am trying to select a specific chart layout in my macro/VB code but
can not tell what to use. When I use the macro record to record the chart layout type I want to use, it looks like this: ActiveChart.ApplyLayout (5) ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.DataTable.Select but ApplyLayout (5) does not work when I try to run the macro. I get an "item with specified name wasn't found" error. I hope someone can help?? Thanks! -- mfg2529 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I keep getting ##### in a cell when I type in a dollar figure. | Excel Discussion (Misc queries) | |||
| How do I type in full figure | Charts and Charting in Excel | |||
| Code for Print Layout | Excel Discussion (Misc queries) | |||
| how to type a minues figure | New Users to Excel | |||
| Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel | |||
Linear Mode
