Manually changing a chart won't update

If I make a chart and set the legend to the right, my plot area adjusts so that the legend has room. Same thing happens if then set the legend to the top, my plot area adjusts. Then if I manually change my plot area, and set the legend back to the right, my plot area doesn't adjust anymore.

Is there a way to get my plot area to reset? or to get the new area to be my "base case"

Originally Posted by MrShorty

As one who almost always does this so that the legend sits inside of the plot area, I have found that, once you "break" the link between "adjust the plot area so that the legend fits outside the plot area", Excel cannot recreate that link. Adjusting the plot area after placing the legend is one way to break this link. The other would be to manually drag the legend to a new location.

I do not usually want to recreate the link, so I am not sure how best to do it. The most success I have had is to recreate the chart. As you say, it would be nice to have the necessary formats in a "base case" template, and Excel will allow you to save a chart template that you can apply to new charts: https://support.office.com/en-us/art...6-9F5E55187F2A Perhaps the way forward is to save a chart template before you manually change the plot area with all of the other formatting as you want it. Then, create a new chart from that template each time.

This is perfect! Thanks