| 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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
VBA and Chart Legends (2003 and 2007)
Hi,
Not a bug but a difference between referencing the Legend object position property and the Selection object. xlLegendPositionBottom and xlbottom both return the same value, -4107 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Barb Reinhardt" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
VBA and Chart Legends (2003 and 2007)
I'm getting reports that it gives a run time error when
xlLegendPositionBottom is being used. -- HTH, Barb Reinhardt "Andy Pope" wrote: Hi, Not a bug but a difference between referencing the Legend object position property and the Selection object. xlLegendPositionBottom and xlbottom both return the same value, -4107 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Barb Reinhardt" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
VBA and Chart Legends (2003 and 2007)
In my quick test using either constant in both code examples worked.
Do you have more details when failing, such as chart and data type. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Barb Reinhardt" wrote in message ... I'm getting reports that it gives a run time error when xlLegendPositionBottom is being used. -- HTH, Barb Reinhardt "Andy Pope" wrote: Hi, Not a bug but a difference between referencing the Legend object position property and the Selection object. xlLegendPositionBottom and xlbottom both return the same value, -4107 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Barb Reinhardt" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
VBA and Chart Legends (2003 and 2007)
If I get any more details, I'll let you know.
-- HTH, Barb Reinhardt "Andy Pope" wrote: In my quick test using either constant in both code examples worked. Do you have more details when failing, such as chart and data type. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Barb Reinhardt" wrote in message ... I'm getting reports that it gives a run time error when xlLegendPositionBottom is being used. -- HTH, Barb Reinhardt "Andy Pope" wrote: Hi, Not a bug but a difference between referencing the Legend object position property and the Selection object. xlLegendPositionBottom and xlbottom both return the same value, -4107 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Barb Reinhardt" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
