Forum Discussion

agwalsh's avatar
agwalsh
Brass Contributor
Sep 22, 2025
Solved

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's avatar
    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

     

     

     

Kidd_Ip's avatar
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

 

 

 

Resources