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

Hi Dave,

It sounds like the issue you're experiencing is due to a formatting problem. Fortunately, there are a few things you can try to fix it.

1. First, try adjusting the size of the chart area. To do this, click on the chart to select it, then click and drag the handles on the edges of the chart to resize it. This may help to create more space for the legend.
   
2. If that doesn't work, you can try adjusting the size and position of the legend itself. To do this, click on the legend to select it, then click and drag the handles on the edges of the legend to resize it. You can also click and drag the legend to move it to a different location on the chart.
   
3. If neither of these solutions work, you can try adjusting the chart's layout options. To do this, right-click on the chart and select "Format Chart Area". In the Format Chart Area dialog box, click on the "Layout" tab. From here, you can adjust the size and position of the plot area and legend.
   
4. Finally, if none of these solutions work, you can try resetting the chart to its default settings. To do this, right-click on the chart and select "Reset to Match Style".

I hope one of these solutions works for you. Let me know if you have any other questions or if there's anything else I can help you with.

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"David Billigmeier" wrote:

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

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.
--
Regards,
Dave


"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"David Billigmeier" wrote:

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

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"David Billigmeier" wrote:

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.
--
Regards,
Dave


"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"David Billigmeier" wrote:

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

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

--
Regards,
Dave


"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"David Billigmeier" wrote:

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.
--
Regards,
Dave


"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"David Billigmeier" wrote:

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