New answers tagged

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,...
Sean's user avatar
  • 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().
doubleunary's user avatar
  • 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 =...
doubleunary's user avatar
  • 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" ...
Dias's user avatar
  • 11

Top 50 recent answers are included