Select Orientation under Legends.
Select one of the following to place the legend relative to the chart.
Locaton
Location relative to the chart
apOrientationBottom (default)
Bottom
apOrientation Left
Left
apOrientationRight
Right
apOrientationTop
Top
More information
Design XY plot legends.