Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi, I am plotting some data but I only want to show the trends so
I've hidden all the scatter points and am showing just the linear trendlines. However, the legend entries are Linear (April), Linear (May) etc...is there any way to just show the series names without "Linear"? Thanks. |
#2
![]() |
|||
|
|||
![]()
Yes, you can remove the word "Linear" from the trendline legend entry by following these steps:
Now, the trendline legend entry should only show the series names without the word "Linear".
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Right-click the trendline.
In the pop-up menu choose Format Trendline. In the dialog box that appears, choose the Options tab. Under Trendline name, select Custom and fill in the new name. -- Jim Cone Portland, Oregon USA . http://www.contextures.com/excel-sort-addin.html . (editorial review of special sort excel add-in (30 ways to sort) "dschneiderch" wrote in message ... Hi, I am plotting some data but I only want to show the trends so I've hidden all the scatter points and am showing just the linear trendlines. However, the legend entries are Linear (April), Linear (May) etc...is there any way to just show the series names without "Linear"? Thanks. |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Pada Selasa, 20 Desember 2011 0:23:01 UTC+7, dschneiderch menulis:
Hi, I am plotting some data but I only want to show the trends so I've hidden all the scatter points and am showing just the linear trendlines. However, the legend entries are Linear (April), Linear (May) etc...is there any way to just show the series names without "Linear"? Thanks. klik this link; http://www.mathworks.com/help/matlab...ding-data.html i think that is very easy to understand trend of data |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
在 2011年12月20日星期二 UTC+8上午2:24:32,Jim Cone写道:
Right-click the trendline. In the pop-up menu choose Format Trendline. In the dialog box that appears, choose the Options tab. Under Trendline name, select Custom and fill in the new name. -- Jim Cone Portland, Oregon USA . http://www.contextures.com/excel-sort-addin.html . (editorial review of special sort excel add-in (30 ways to sort) "dschneiderch" wrote in message ... Hi, I am plotting some data but I only want to show the trends so I've hidden all the scatter points and am showing just the linear trendlines. However, the legend entries are Linear (April), Linear (May) etc...is there any way to just show the series names without "Linear"? Thanks. good answer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit legend entry for a trendline | Charts and Charting in Excel | |||
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Data entry "+" results in "294" in XLS | Excel Discussion (Misc queries) |