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

excel

Kidd_Ip

Sep 24, 2025

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

2 Replies

agwalsh
Brass Contributor
Sep 29, 2025
So I think the answer is No, unless you use VBA :-) Thank you for your help. Much appreciated.

Kidd_Ip

MVP

Sep 24, 2025

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

Forum Discussion

Legend setting in Excel charts - possible to set default to go to top of chart

2 Replies

Resources