How to create a dashed line (TrendLine)

I have a line chart now, I want one of them (the red line) to be dashed line. How can I do this? Capture.PNG

Best Answer

  • Unknown
    Accepted Answer

    There is a chart property that allows you to add a linear regression line, but it's only available in line charts with a single series.

     

    If you want to see a trend line through multiple points you could switch to a scatter chart and put the date on the x axis. This chart type allows you to add regression lines (as a chart property) to a scatter plot. See example below. 

     

    RegressionLines.PNG

Answers

This discussion has been closed.