Forum Discussion

Benj's avatar
Benj
New Member
10 years ago

Trend Lines

Is it possible to add trendlines to a scatter graph, like you can in Excel.   One example would be adding a linear trendline and being able to see the equation to get correlation coefficients.   ...
DouglasAPlummer's avatar
DouglasAPlummer
New Member
10 years ago

Anyone NOT having trend lines options show after the update for all type expected?

 

Note says " data in the following charts: line, scatter, bubble, column, area, and combo charts" and I have in scatter. But for a column or line chart no "Trend Line" as expected from the release notes and video.

 

Column chart options below.

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

It is the Clustered Column Chart that has it, not the Stacked. And for Line Chart and Clustered Column Chart, make sure that your X-Axis is set to "Continuous" and not "Categorical"

  • DouglasAPlummer's avatar
    DouglasAPlummer
    New Member
    10 years ago

    thank (again). Being able to do when categorical would be nice but this is a step in the right direction.

    • Sean's avatar
      Sean
      Community Champion
      10 years ago

      Anonymous is absolutely right!

       

      even your standard YYYY-MM is unfortunately but understandably not recognized

       

      You have to start with a Date Column and then just keep Year and Month.

       

      Month Numbers only - work though.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        So anyone who needs weekly trends is out of luck?