Legend 2 Columns

K

Kris

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,
 
J

Jon Peltier

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

- Jon
 
K

Kris

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.
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove "linear" from trendline legend entry 2
Problem with xy scatter with dates 7
Non Linear Scatter plot, need to find y value 3
legend problem in mixed line-scatter graph Excel 2007 0
XY scatter plot 3
Sorting and filtering text 0
problem with scatter diagram excel 2007 2
deleting legend keys in mixed line-scatter graph not correct 1

Top