View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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?