Is there a way to split the legend of a line chart with 1 Y-axis in 2 parts.
One option is to make an extra text box to copy a part of the legend, but
this will not be updates when I change something on the series.
is there another option ?

I'm not clear on what you want to do? Are you trying to show a legend on the
right hand side for 3 of 6 series and then a separate legend on the other
side for the remaining 3? Or are you trying to put a space or line in the
legend to that 3 items appear above it and 3 items below it?

Part of the reason I'm confused is I don't know how you copied part of the
legend to a textbox - I can't duplicate that in 2003?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Roland" wrote:

Is there a way to split the legend of a line chart with 1 Y-axis in 2 parts.
One option is to make an extra text box to copy a part of the legend, but
this will not be updates when I change something on the series.
is there another option ?

1st option, 2 x 3 series split in 2 separate parts

"Shane Devenshire" wrote:

I'm not clear on what you want to do? Are you trying to show a legend on the
right hand side for 3 of 6 series and then a separate legend on the other
side for the remaining 3? Or are you trying to put a space or line in the
legend to that 3 items appear above it and 3 items below it?

Part of the reason I'm confused is I don't know how you copied part of the
legend to a textbox - I can't duplicate that in 2003?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Roland" wrote:

Is there a way to split the legend of a line chart with 1 Y-axis in 2 parts.
One option is to make an extra text box to copy a part of the legend, but
this will not be updates when I change something on the series.
is there another option ?

There is one legend per chart, and it cannot be subdivided. You could always
fake it with a group of shapes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Roland" wrote in message
...
Is there a way to split the legend of a line chart with 1 Y-axis in 2
parts.
One option is to make an extra text box to copy a part of the legend, but
this will not be updates when I change something on the series.
is there another option ?