Forum Discussion
Legend setting in Excel charts - possible to set default to go to top of chart
hello I hope you are well. When I add a legend to a chart in Excel, it invariably defaults to the bottom or side, rather than the top. Is there a way to change this default behaviour? Thank you
Try this if you are comfortable with VBA:
Sub SetLegendTop()
Dim ch As Chart
For Each ch In ActiveSheet.ChartObjects
ch.Chart.Legend.Position = xlLegendPositionTop
Next ch
End Sub