Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-sheets-charts-trendlines]

1
vote
1answer
18 views

Compare dates from two years in a graph when dates not identical in Google Sheets

I can’t figure out how to compare two data sets with date intervals form each year. Only the start and end date are the same days, the rest is spread over the period. And there can be more points in ...
0
votes
1answer
120 views

How to make Google Sheets draw trends in a spreadsheet

I have a graph on Google Sheets (based on two columns) that plots many points (think of it like the stock market): I would like the graph to not show the micro data and instead show trends.. ...
0
votes
1answer
39 views

Is Google Sheets capable of making a gantt-like chart like this? If so, how?

I have two columns in a spreadsheet: A1:A100 has start times, and B1:B100 has duration. I am trying to create a chart that looks something like this, where each row gets a vertical line placed at the ...
0
votes
0answers
245 views

Google spreadsheets: how to add customized trendlines?

Consider a very simple scenario with two columns of data in a google spreadsheet. I want to add a trendline to a plot but the function I know which must be applied does not exist in the options (e.g. ...
-1
votes
1answer
726 views

Google Sheets trendline broken; file unavailable

In Google Sheets, I've created a line graph. I want to add a trend line. I do so by clicking the blue line and selecting Linear from the trendline dropdown. No trendline appears. Then when I right ...
6
votes
1answer
10k views

Add average line to scatter graph

I have the following scatter plot in Google Sheets and I would like to add a line that averages all my points. Can I do that and if yes, how?