Show trend line but not line

[#1]

Hi community,

Is there away to show the trendline but not the line on a chart?

Regards,

Brandon B

[#2]

Can you draw a picture of what you are looking for?

[#3]

I want the line at the top to just show the trendline, not the actual data that its overlapping.

[#4 · Accepted solution]

See attached. Do you have the circled Invisilble option? This will hide the actual values and the trendline still displays

[swarup_malli]

I have a similar requirement, But

- I want to retain the legends..if I click on the invisible in the chart properties..the line along with the legend disappears..

-Another method would be to create another experession which mimics the trend line..so that legend is visible..but how to to find the formula the legend is using ?

Swarup

[#6]

i have a similar issue. how to solve this?

Regards, Uguudei

[swarup_malli]

Uguudei,

I solved it by taking screenshots of legends,then using that legend screen shot as an image on the chart

Regards

SM

[#8]

You can change the color of the chart instead doing this. Just change the chart color to white or your background color......