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