Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
VBA and Chart Legends (2003 and 2007)
I have this snippet of code to update the legends to the bottom of the chart
For Each objCht In WS.ChartObjects With objCht.Chart .Legend.Position = xlLegendPositionBottom End With Next objCht If I record this in 2003 OR 2007, I get this ActiveChart.Legend.Select Selection.Position = xlBottom But if I type .Legend.Position in the original snippet, xlLegendPositionBottom is an option and xlBottom is not an option. In Office 2007, it appears to Gack on xlLegendPositionBottom and prefers xlBottom. Is this a bug, or am I missing something? Thanks, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Legends | Charts and Charting in Excel | |||
formatting chart legends | Charts and Charting in Excel | |||
Chart legends question | Excel Discussion (Misc queries) | |||
Help, I can't resize chart legends on my axes or titles | Charts and Charting in Excel | |||
bar chart with multiple legends? | Charts and Charting in Excel |