Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() G'day, Im having trouble resizing the legend from 3 lines to 1. I have used a scatter chart and then Add TrendlineMoving average. The legend that is auto-generated is "10 per. Mov. Avg. (PROJECTED INITIAL YELD" The title is broken up into 3 lines as above, and no matter how much I resize or how much big I make the legend area or how small the font, it INSISTS on using 3 lines. Because the title is auto-generated (10 per. Mov. Avg.....) there is nowhere where I can actually edit the title eg make it shorter, or remove the alt-enter line breaks (if thats what it is). The legend title does not appear in chart optionlegend label or axis-labels. It doesnt appear anywhere except on the graph in the legend. And the whole title should definitely fit on one line because there is plenty of space and Ive seen it on another graph but cant replicate it. Your help is much appreciated, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing trendline from legend | Excel Discussion (Misc queries) | |||
Can I add a title to the legend? | Charts and Charting in Excel | |||
Resizing the legend | Charts and Charting in Excel | |||
Can I remove just one title within a graph legend and not hide th. | Charts and Charting in Excel | |||
Capture the legend title. Help | Charts and Charting in Excel |