New answers tagged google-sheets-dates
0
votes
How can I horizontally space data points on a chart when the dates are arbitrary?
Thank you to Tedinoz for the link to Discrete vs Continuous.
Once I discovered this link, I solved the issue I'd had for several hours within a matter of minutes.
The link makes it clear that
In line,...
- 1
0
votes
Accepted
Excluding specific range in Google Sheets
Use row() and isbetween(), like this:
=min(filter(C4:C, C4:C > today(), not(isbetween(row(C4:C), 58, 64))))
See row() and isbetween().
- 13.2k
1
vote
Accepted
Automatic way to select a range for a formula based on the date
Use filter(), like this:
=map($A2:$A, B2:B, lambda(date, budget,
if(
isnumber(date) * isnumber(budget),
budget -
sum(iferror(filter(
Activities!C2:C,
Activities!$A2:$A =...
- 13.2k
1
vote
How can I horizontally space data points on a chart when the dates are arbitrary?
I know it is a late response, but for those searching for the answer as I just did:
This is possible and automatically done if you choose Line Chart, Area Chart, and their "Stacked" ...
- 11
Top 50 recent answers are included