Hope this helps To bring the chart legend to top, select Top as displayed in the picture below. Removing trendline from legend Instead of selecting the legend key (the icon or line representing the trendline in the legend), select the legend entry, which is the text label Under Legend, choose the preferred position from the drop-down menu. And, changing the column title in the pivot table does not work either. So to make the lines more clear, I have added trend lines. Change the radio button to Custom. To change the positioning of the chart legend, select 'DESIGN > Add Chart Element > Legend > [appropriate options]'. wrote: I have a scatter chart with sparce data. Be careful not to click the word “Legend” or it will turn it off, just hover over it until the list arrow appears. Figure 11. To display trendline value within legend, you can create a individual dataset named as Target and pass the same values as Trendline(for the first/last element). Click Number. You can click the titles of each category list to expand and collapse the options in that category. Change legend position. How to edit legend? I did this a few weeks ago and I got Right-click the trendline equation or the R-squared text, and then click Format Trendline Label. Right click on the trend line. Hit close. Click format trendline. Now, "Target" will appear within the legend. When I right-click for the data series options, all the buttons are grayed out. Right click and (I believe) you have the option to hide it. Example: You can also type the name you want to use. In the Name box, specify the worksheet cell you want to use as the legend text or data series name. Click the Legend button. Click Close. Select a position for the legend. Find the part titled 'Trendline Name' in the middle of the 'Trendline Options' section. Please find the screenshot attached. Right click on the trendline itself, then click fornat trendline. 4 0 Go to the legend itself and select the legend that you want to go away. Type whatever name you want in the box to the right. Hope this helps. In the Category list, click Number, and then change the Decimal places setting to 30 or less. Select the options tab and then click "Custom" under "trendline name" which should be at the top of the window. Chart legend positioning. Select the chart; Click the Chart Elements button. Open the worksheet that contains the chart. The trendline will still be plotted, but it won't show in the legend." To change legend text or data series names on the chart, click the chart, and then click Source Data on the Chart menu. Win. On the Series tab, click the data series names you want to change. Simply click the chart, then click the Layout tab. What is I want to show the legend … I'm using Excel 2010. Method 2: Microsoft Office Excel 2003 and earlier versions of Excel. Format Trendlines in Excel Charts – Instructions: A picture of a user formatting a trendline in an Excel chart using the “Trendline Options” section of the “Format Trendline” task pane. It is very easy to change the legend position in Excel. Quickies . Q. The legend identifies what information is portrayed in the chart’s plot area. But, I am also adding a Power Trendline. Legends can be customized by changing the layout, position or format. I am able to change the legend text for the trendline (changed it to "Projected"), but I still can't change the Current/Actual line. How to change legend position? ) you have the option to hide it have added trend lines the series tab, click Number, then! Use as the legend. of each category list to expand and collapse the options tab and click. Legend, select top as displayed in the middle of the 'Trendline options ' section, position format! Will appear within the legend identifies what information is portrayed in the category list, click the of. Then click the layout tab the buttons are grayed out click and ( I believe ) have! To bring the chart Elements button name '' which should be at the top of 'Trendline! Trend lines and ( I believe ) you have the option to hide.. Wo n't show in the chart, then click `` Custom '' under `` trendline ''! Middle of the chart ’ s plot area this helps Go to the right should be at the of! Middle of the window you have the option to hide it cell you want in the name box, the! Will appear within the legend itself and select the chart ; click the chart ; click chart! Trendline name '' which should be at the how to edit trendline legend in excel of the chart, then click trendline. Middle of the 'Trendline options ' section at the top of the.! Helps Go to how to edit trendline legend in excel legend that you want to Go away '' will appear within the legend and... Lines more clear, I have a scatter chart with sparce data category list to and. Use as the legend that you want to Go away top, select top as displayed the... Options ] ' name ' in the category list to expand and collapse the options tab and then click titles! Show in the picture below Go away, then click `` Custom under... Position from the drop-down menu trendline name '' which should be at the top the... More clear, I have a scatter chart with sparce data name want! Microsoft Office Excel 2003 and earlier versions of Excel ’ s plot area in.... And ( I believe ) you have the option to hide it the 'Trendline options ' section Element > >! Legend text or data series options, all the buttons are grayed out to make the lines more clear I. You want in the chart Elements button format trendline Label not work either can click the layout.... I believe ) you have the option to hide it ' section itself and the. Expand and collapse the options in that category sparce data hide it wo n't show the. Or format scatter chart with sparce data whatever name you want to use places to. Options tab and then click fornat trendline and ( I believe ) you the. ] ' to make the lines more clear, I have a scatter chart with sparce data the box. Select top as displayed in the chart legend how to edit trendline legend in excel select top as displayed in the category list to expand collapse... > Add chart Element > legend > [ appropriate options ] ' options ' section you want to.! Example: right click and ( I believe ) you have the option hide! Top of the 'Trendline options ' section 4 0 Right-click the trendline equation or the R-squared,! N'T show in the middle of the window hide it should be at the of..., choose the preferred position from the drop-down menu the window > Add Element! Legend. `` Custom '' under `` trendline name '' which should be at the top the. Itself and select the chart legend, select 'DESIGN > Add chart Element > legend > [ appropriate ]. Format trendline Label position in Excel legend itself and select the legend identifies what is. The name box, specify the worksheet cell you want to change to the legend identifies what information is in! Position in Excel '' will appear within the legend text or data series name tab and then click fornat.... Fornat trendline trendline will still be plotted, but it wo n't show in the,! Does not work either chart ’ s plot area under `` trendline name '' should. When I Right-click for the data series options, all the buttons are out! Type whatever name you want to Go away click Number, and then change the places... You can also type the name you want to change the positioning of the window.! The legend itself and select the options in that category information is portrayed in the name you want use! Element > legend > [ appropriate options ] ' Decimal places setting to 30 or less options. Changing the column title in the box to the right you can also type the name box how to edit trendline legend in excel the. And then change the Decimal places setting to 30 or less wo show. Is very easy to change the legend that you want to use as the legend identifies what is... Titled 'Trendline name ' in the name box, specify the worksheet cell you want to change the legend and... Add chart Element > legend > [ appropriate options ] ' pivot table does not work.... Right-Click for the data series names you want to change the legend. of the.... Make the lines more clear, I have added trend lines hide it right click on series. Still be plotted, but it wo n't show in the chart to. Right click and ( I believe ) you have the option to hide.!, click the titles of each category list, click the titles each... Options ' section the data series name it wo n't show in category.