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
1st option, 2 x 3 series split in 2 separate parts
There is one legend per chart, and it cannot be subdivided. You could always
fake it with a group of shapes.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.