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

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How do I set a Trend Line and Remove the Data Line (https://www.excelbanter.com/charts-charting-excel/199850-how-do-i-set-trend-line-remove-data-line.html)

FlexoC

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

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?

Andy Pope

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

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" wrote in message
...
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?

FlexoC

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

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" wrote in message
...
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?

All times are GMT +1. The time now is 05:53 AM.