How do I set a Trend Line and Remove the Data Line

's Computer Specifications

Is it possible to add a trend line to a chart but remove the data line from
view and still keep the data available on the chart?

's Computer Specifications

Hi,

Rather than remove the series that the trend line is based upon format it to
have no markers or line colour.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"FlexoC" <(E-Mail Removed)> wrote in message
news:C7C5C91D-06F6-44FF-A095-(E-Mail Removed)...
> Is it possible to add a trend line to a chart but remove the data line
> from
> view and still keep the data available on the chart?

's Computer Specifications

Hi Andy,

Thank you so much! This is perfect.

Lisa

"Andy Pope" wrote:

> Hi,
>
> Rather than remove the series that the trend line is based upon format it to
> have no markers or line colour.
>
> Cheers
> Andy
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "FlexoC" <(E-Mail Removed)> wrote in message
> news:C7C5C91D-06F6-44FF-A095-(E-Mail Removed)...
> > Is it possible to add a trend line to a chart but remove the data line
> > from
> > view and still keep the data available on the chart?
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Regression - trend line vs. data points??	WA	Microsoft Excel Charting	1	15th Jan 2010 07:54 PM
Making a trend line for several series of data	Raquel	Microsoft Excel Worksheet Functions	0	6th Oct 2008 07:14 PM
Trend Line Behind Data?	Richard Wood	Microsoft Excel Charting	6	8th Jul 2008 10:00 PM
Finding Data Point INSIDE a Trend Line?	HighLow	Microsoft Excel Misc	3	30th Dec 2003 04:26 AM
Trend Line data point weight	Greta	Microsoft Excel Worksheet Functions	1	25th Nov 2003 02:06 AM