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