Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
white space deletion | Excel Worksheet Functions | |||
Too much white space to the right of a pie chart! How to eliminate | Charts and Charting in Excel | |||
White Space in a Cell | New Users to Excel | |||
Extra white space between cells | Excel Discussion (Misc queries) | |||
White Space in PDF from Excel | Excel Discussion (Misc queries) |