Legend area white space
 

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?

Legend area white space
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Kent McPherson" wrote in message
...
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?

Legend area white space
 

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.

"Jon Peltier" wrote in message
...
Click on the plot area (the rectangle defined by the axes) and stretch it
into the white space.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Kent McPherson" wrote in message
...
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?

Legend area white space
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kent McPherson" wrote in message
...
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?

Legend area white space
 

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" wrote in message
...
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kent McPherson" wrote in message
...
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?

Legend area white space
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kent McPherson" wrote in message
...
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" wrote in message
...
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kent McPherson" wrote in message
...
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?

Legend area white space
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Kent McPherson" wrote in message
...
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.

"Jon Peltier" wrote in message
...
Click on the plot area (the rectangle defined by the axes) and stretch it
into the white space.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Kent McPherson" wrote in message
...
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?