My legends have a lot of x-y scatter chart data points and are long and hard
to read. Is there a way to make them into two columns instead of one?
Thanks,

Hot off the press:Legends in Excel Charts - Formats, Size, Shape, and
Positionhttp://peltiertech.com/WordPress/legends-excel-charts-formats-size-shape-position/

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



"Kris" wrote in message
...
My legends have a lot of x-y scatter chart data points and are long and
hard
to read. Is there a way to make them into two columns instead of one?
Thanks,

Thanks Jon,

My labels are so long that they weren't allowing the legend to display more
than one column, unless I expand it over the chart area. There doesn't appear
to be a wrap text feature for individual legend cells. I'll have to shorten
the labels.

"Jon Peltier" wrote:

Hot off the press:Legends in Excel Charts - Formats, Size, Shape, and
Positionhttp://peltiertech.com/WordPress/legends-excel-charts-formats-size-shape-position/

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



"Kris" wrote in message
...
My legends have a lot of x-y scatter chart data points and are long and
hard
to read. Is there a way to make them into two columns instead of one?
Thanks,

Shorter labels are better anyway, easier to read and absorb.

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


"Kris" wrote in message
...
Thanks Jon,

My labels are so long that they weren't allowing the legend to display
more
than one column, unless I expand it over the chart area. There doesn't
appear
to be a wrap text feature for individual legend cells. I'll have to
shorten
the labels.

"Jon Peltier" wrote:

Hot off the press:Legends in Excel Charts - Formats, Size, Shape, and
Positionhttp://peltiertech.com/WordPress/legends-excel-charts-formats-size-shape-position/

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



"Kris" wrote in message
...
My legends have a lot of x-y scatter chart data points and are long and
hard
to read. Is there a way to make them into two columns instead of one?
Thanks,

Hi,

You can manually resize and reshape the legend by dragging its sizing
handle. Placement across the bottom of the chart by double-clicking the
legend and choosing the Placement tab, and choose Bottom.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Kris" wrote:

My legends have a lot of x-y scatter chart data points and are long and hard
to read. Is there a way to make them into two columns instead of one?
Thanks,