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