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
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 ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______