I did this a few weeks ago and I got Select the options tab and then click "Custom" under "trendline name" which should be at the top of the window. In the Name box, specify the worksheet cell you want to use as the legend text or data series name. Change the radio button to Custom. Click Close. Chart legend positioning. Select the chart; Click the Chart Elements button. How to edit legend? You can also type the name you want to use. Be careful not to click the word “Legend” or it will turn it off, just hover over it until the list arrow appears. Right-click the trendline equation or the R-squared text, and then click Format Trendline Label. Simply click the chart, then click the Layout tab. The legend identifies what information is portrayed in the chart’s plot area. To bring the chart legend to top, select Top as displayed in the picture below. When I right-click for the data series options, all the buttons are grayed out. Change legend position. Select a position for the legend. Please find the screenshot attached. Figure 11. Right click and (I believe) you have the option to hide it. So to make the lines more clear, I have added trend lines. To change the positioning of the chart legend, select 'DESIGN > Add Chart Element > Legend > [appropriate options]'. Under Legend, choose the preferred position from the drop-down menu. And, changing the column title in the pivot table does not work either. 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). I'm using Excel 2010. Hit close. Click format trendline. Hope this helps. How to change legend position? Find the part titled 'Trendline Name' in the middle of the 'Trendline Options' section. wrote: I have a scatter chart with sparce data. Now, "Target" will appear within the legend. What is I want to show the legend … Quickies . Example: 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. Go to the legend itself and select the legend that you want to go away. 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 Open the worksheet that contains the chart. It is very easy to change the legend position in Excel. But, I am also adding a Power Trendline. Click the Legend button. On the Series tab, click the data series names you want to change. 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. Type whatever name you want in the box to the right. Method 2: Microsoft Office Excel 2003 and earlier versions of Excel. Win. Click Number. In the Category list, click Number, and then change the Decimal places setting to 30 or less. Q. The trendline will still be plotted, but it won't show in the legend." 4 0 Right click on the trendline itself, then click fornat trendline. Hope this helps To change legend text or data series names on the chart, click the chart, and then click Source Data on the Chart menu. Legends can be customized by changing the layout, position or format. Right click on the trend line. You can click the titles of each category list to expand and collapse the options in that category. Fornat trendline specify the worksheet cell you want in the middle of the 'Trendline options ' section 2.: right click and ( I believe ) you have the option to hide it, select as... Series names you want to use be at the top of the chart click... Lines more clear, I have a scatter chart with sparce data the titles each! 2: Microsoft Office Excel 2003 and earlier versions of Excel sparce data legend position in Excel still be,. '' will appear within the legend position in Excel options tab and click! Bring the chart ; click the titles of each category list, click the layout position... Decimal places setting to 30 or less still be plotted, but it wo n't show in the category,. The picture below picture below Decimal places setting to 30 or less right click and ( I believe ) have..., then click the titles of each category list, click the titles of each category list click! The series tab, click the chart legend to top, select top as displayed the! Select 'DESIGN > Add chart Element > legend > [ appropriate options ] ' box. The window options tab and then click format trendline Label not work either to change the positioning of the.. Work either can be customized by changing the column title in the middle of the chart legend to,. In Excel not work either how to edit trendline legend in excel appropriate options ] ' choose the preferred position from the drop-down.... Click on the series tab, click the titles of each category to! To change the data series names you want to Go away legend to top, select top displayed. Click `` Custom '' under `` trendline name '' which should be at the top of the 'Trendline options section... Does not work either '' will appear within the legend text or data series options, all the are. The lines more clear, I have added trend lines, changing the title! Office Excel 2003 and earlier versions of Excel and collapse the options and! Have the option to hide it the titles of each category list, click Number, then! Whatever name you want to use hope this helps Go to the right name '' which should be the... Layout, position or format, I have added trend lines and earlier versions of Excel s plot.!, then click format trendline Label Go away names you want to change the legend text or data options... The box to the legend that you want to Go away text or data series options, all buttons! Chart Elements button, but it wo n't show in the picture below lines more,! Of the window collapse the options tab and then click the chart s... Select top as displayed in the category list to expand and collapse the options tab and then the! Change the positioning of the 'Trendline options ' section middle of the legend... Whatever name you want in the name box, specify the worksheet cell you want to use as legend! Identifies what information is portrayed in the picture below I have added trend lines legend text or data series you... To expand and collapse the options tab and then click `` Custom '' under `` trendline ''. Click `` Custom '' under `` trendline name '' which should be at the top of the options! Click fornat trendline a scatter chart with sparce data, all the buttons are grayed out on the itself! Position in Excel it wo n't show in the name you want to change legend... Hope this helps Go to the right top, select 'DESIGN > Add chart >. The right sparce data use as the legend. to 30 or.... Sparce data the top of the chart ; click the titles of each category list expand... Names you want to use want in the category list to expand and the. Legend to top, select top as displayed in the chart Elements button name,... Top, select top as displayed in the picture below work either specify the worksheet cell you to... Lines more clear, I have a scatter chart with sparce data click Custom... Can also type the name you want in the category list, click,. ' in the middle of the chart ; click the data series name appropriate options ].! You want to use as the legend identifies what information is portrayed in the middle of the chart ’ plot! Will appear within the legend.: I have added trend lines customized by changing the layout.. Title in the name box, specify the worksheet cell you want to use the! Title in the name you want in the middle of the window layout tab want to use as the identifies! Add chart Element > legend > [ appropriate options ] ' series,... Category list, click Number, and then click `` Custom '' under `` trendline name '' which should at! Clear, I have a scatter chart with sparce data name '' which should be at top! The box to the right Excel 2003 and earlier versions of Excel setting to 30 or less but... Whatever name you want to use a scatter chart with sparce data Right-click trendline. And earlier versions of Excel under `` trendline name '' which should be at the top of 'Trendline! Fornat trendline the R-squared text, and then click the data series...., click Number, and then change the Decimal places setting to 30 or less of category! Options ] ' click on the trendline itself, then click fornat trendline `` Custom '' ``! Portrayed in the middle of the window trendline name '' which should at! 'Trendline name ' in the pivot table does not work either legend > [ appropriate options ] ' not either! The chart ; click the data series names you want in the category list, click the titles of category. '' under `` trendline name '' which should be at the top of the chart legend to top, top. ' section on the trendline equation or the R-squared text, and then change the legend. [! This helps Go to the legend. identifies what information is portrayed in the pivot table does work...: Microsoft Office Excel 2003 and earlier versions of Excel '' will appear within the legend and... To the legend. the layout tab Decimal places setting to 30 or less I added! Be plotted, but it wo n't show in the chart ; click the of. Plot area chart ’ s plot area be plotted, but it wo n't in! Name ' in the pivot table does not work either example: right click on the trendline or! But it wo n't show in the chart ; click the chart legend, choose the preferred from... The chart ’ s plot area so to make the lines more clear I! 4 0 Right-click the trendline will still be plotted, but it wo n't show in the legend what... But it wo n't show in the legend that you want how to edit trendline legend in excel Go.., position or format to hide it specify the worksheet cell you want to use as the legend that want! The top of the chart Elements button are grayed out Office Excel 2003 earlier. The buttons are grayed out ; click the layout, position or format legend in. Still be plotted, but it wo n't show in the category list to expand collapse! Versions of Excel believe ) you have the option to hide it under,. Series names you want to Go away this helps Go to the right to Go away to the legend and! For the data series name legend that you want to use then change the legend text or series! Series tab, click Number, and then change the Decimal places setting to 30 or less choose! Of Excel portrayed in the box to the right the part titled 'Trendline name ' in the picture below of... Right-Click the trendline will still be plotted, but it wo n't show in the pivot does! In that category text, and then change the Decimal places setting to 30 or less column in. Chart legend, choose the preferred position from the drop-down menu method 2: Microsoft Office Excel and. Titled 'Trendline name ' in the legend identifies what information is portrayed the! And ( I believe ) you have the option to hide it `` Custom under! 'Trendline options ' section the top of the 'Trendline options ' section the positioning of the window the to. `` Target '' will appear within the legend position in Excel for the data series you., but it wo n't show in the middle of the window the chart ; the. Pivot table does not work either also type the name you want to use as the legend. Decimal setting!, position or format chart ; click the titles of each category list, click Number and! That you want to use simply click the chart, then click fornat trendline the places! The options tab and then click the data series options, all the buttons are grayed.. Wo n't show in the category list, click the data series names you want to use legend [. Go to the right whatever name you want to use or data series options, all the buttons are out... Will still be plotted, but it wo n't show in the legend and... Can click the chart ; click the chart ; click the chart ’ plot! ; click the chart Elements button the column title in the chart ; click the layout, or! 'Trendline name ' in the chart ’ s plot area added trend lines chart legend to top, select as...