Excel - split legend

Asked By Rolan on 08-Feb-09 04:55 AM
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 ?

ShaneDevenshir replied on 08-Feb-09 12:26 PM
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

Shane Devenshire
Rolan replied on 08-Feb-09 01:24 PM
1st option, 2 x 3 series split in 2 separate parts
Jon Peltier replied on 08-Feb-09 06:41 PM
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.