Legend area white space

[Kent McPherson]

I have bar charts where I have turned off the legend because my selection
range includes series descriptors. For example:

Descriptor 1 100
Descriptor 2 200
Descriptor 3 300


Because my specific example has fairly long strings for the descriptors,
there is significant white space where the legend would be even though I
have the legend turned off. If I shorten the descriptors, the white space
goes away. I want long descriptors to make the values clear but not all the
white space. Anyone know if I can eliminate this somehow while keeping the
long descriptors?

 

[Jon Peltier]

Click on the plot area (the rectangle defined by the axes) and stretch it
into the white space.

- Jon

 

[Kent McPherson]

I've done that but you can't eliminate the white space if still have long
labels. Looks like maybe I'm stuck with creating shorting descriptors.

 

[Bernard Liengme]

This a strange if, in Chart Options, you specify No Legend , or if you
simply delete the legend then it cannot be using up space - it does not
exist!
Tell us more about this problem.
best wishes

 

[Kent McPherson]

You're right about the legend not being there so it can't take up space.
Maybe a more accurate description is I end up with white space where the
legend would be if I have long strings as the first column of the data range
and I have the alignment angle for the X axis labels anything other than 0
degrees. For example, with -15 degrees, it shows the full string for each
row but I end up with the white space problem. If I set it to 0 degrees,
only every other descriptor shows up but the white space is gone.

 

[Bernard Liengme]

Suggestion, use shorted names in the category column. Use text boxes or
'call outs' (from Drawing toolbar) to identify items on the chart.
best wishes

 

[Jon Peltier]

You mean long category labels on the X axis? You could edit the cells to put
a hard break in the label, to shorten it somewhat.

- Jon