Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to plot a best fit line?
how do u delete the original line after u added a trendline?
|
#2
|
|||
|
|||
If by "the original line" you mean a line that connects the data points,
select the data series, and Format|Selected Data Series|Patterns and check "None" under "Line" Jerry trashcan1620 wrote: how do u delete the original line after u added a trendline? |
#3
|
|||
|
|||
If you delete the series, the trendline will also go away. Double click on the
original series, and on the Patterns tab, choose none for the Line style, and if desired, none for Markers. To hide the legend entry, select the legend, then select the text of the entry, and press the Delete key (don't select the legend key, which is the symbol in front of the text, or you'll delete the series!) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ trashcan1620 wrote: how do u delete the original line after u added a trendline? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
Plot a line? Set dymanic axis Max min | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Adding a text label to a line. | Charts and Charting in Excel |