ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   split legend (https://www.excelbanter.com/charts-charting-excel/219673-split-legend.html)

ROland

split legend
 
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 ?

Shane Devenshire[_2_]

split legend
 
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 ?


ROland

split legend
 
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 ?


Jon Peltier

split legend
 
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 ?





All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com