Logarithmic Trend line

24 views
Skip to first unread message

Eve Minelli Bishop

unread,
Jun 9, 2017, 3:56:39 PM6/9/17
to Google Visualization API
Existe alguma maneira de fazer uma linha de tendencia do tipo Logaritmico no grafico de dispersão?
Consigo fazer no excel, mas nao estou conseguindo reproduzir utilizando o google charts.
Alguém pode me ajudar?

David S.

unread,
Jun 12, 2017, 9:57:00 AM6/12/17
to Google Visualization API
Hi Eve,

New charts in google sheets has a logarithmic trend, however it will be released next week.
Meanwhile, you can calculate according to the following formula: =ArrayFormula(LINEST(Know Y data,LN(Know X data)))
Then calculate and build your own trend. 

Eve Minelli Bishop

unread,
Jun 12, 2017, 10:10:47 AM6/12/17
to Google Visualization API
Thanks David.

Could you help me how do I implement this formula in the trend line of my scatter plot?




Reply all
Reply to author
Forward
0 new messages