Legend Overlaps Chart in Excel 2007

[David Billigmeier]

I converted one of my old Excel 2003 sheets to an Excel 2007 workbook. Some
of the charts in the converted workbook don't seem to be working properly now
though... The main problem is when I go into the "Format Legend" menu and
choose for the legend to be on the Right, it overlaps the plot data area.
Even if I choose "Show the legend without overlapping the chart", nothing
happens. Is this a bug, or do I just have some formatting messed up?

Any idea on how I can get the size of the plot data section to auto-update
based on the size of the legend, similar to how Excel 2003 does?

Thanks,
Dave

 

[Shane Devenshire]

Hi,

a little buggy here. First right click the legend and choose Edit Legend,
then turn on the checkbox for Show the legend without overlapping the chart.
Then click Top and then Right.

 

[David Billigmeier]

Thanks for the response, I tried it but the legend still overlaps the plot
data section. It's like the size of the plot data section doesn't update at
all for any changes.

 

[Shane Devenshire]

Hi,

Ok, that's true. The plot area will not resize to allow the legend to not
overlap, you need to do that manually. Select the plot area and resize it
with the sizing handles. This is not a bug. The Legend will move to avoid
overlap the best it can but the Plot Area has priority over the legend.

 

[David Billigmeier]

Hm, that's too bad, Excel 2003 did it perfectly, not sure why MS decided to
take out that helpful functionality.