Questions tagged [google-sheets-charts-trendlines]
The google-sheets-charts-trendlines tag has no usage guidance.
7
questions
1
vote
1
answer
194
views
Google Sheets - Include a Comparison Trend Line
I am using google sheets to record sales data and have a separate worksheet for each calendar year.
For each calendar year I include a couple of charts which illustrate things like track dollar value ...
- 111
1
vote
1
answer
7k
views
How to automatically fill missing data in Google Spreadsheet
I'm searching for the exact same thing as Google Spreadsheet: How to fill in missing values (inbetween filled values) automatically
I made a spreadsheet for tracking weight, where each row is one day,...
- 13
2
votes
2
answers
844
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 ...
thomasjohansen
1
vote
1
answer
1k
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.. ...
- 1,179
0
votes
1
answer
113
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 ...
-1
votes
1
answer
859
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 ...
- 99
6
votes
1
answer
14k
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?
- 255