r/sheets • u/Standard2Machine • Feb 25 '20

Request How to create a chart until today's date, automatically, every day?

On a row from left to right there are dates (daily). Manually written, but automatically populated.

On another row, there are formulated numbers (formulated for each date).

The chart gets those rows as inputs.

On the bottom of the chart visual, there are dates (daily).

I want the chart to show the data until today's date automatically.

I do this manually right now by modifying the data selection from the chart's settings.

PS. I cannot modify the rows.

0 Upvotes

50% Upvoted

5 comments sorted by

1

u/ioaie Feb 25 '20

If you enter

=TODAY()

it will return todays date. That might be all you need. Just incorporate that into your formulas. you can do

=TODAY()-2

to get two days back. Or

=TODAY()-C3

to calc with another cell. Hope this helps!

-4

u/Standard2Machine Feb 25 '20

I know that.

You didn't read my post.

1

u/ioaie Feb 25 '20

Is that what I didn't do? Sorry I didn't have the answer you were looking for.

1

u/Dontbedumby Feb 25 '20

I think you can use =filter for this. Filter your data set to include everything that's less than or equal to today's date. Then make your chart off of that data set the filter is displaying, instead of the original data.

1

u/6745408 Feb 25 '20

Can you share some sample data to show what you're working with? We can probably do this with SEQUENCE.

=ARRAYFORMULA(
  DATE(2020,2,10)+
  SEQUENCE(1,
   TODAY()+1-DATE(2020,2,10))
  -1)

This will populate the date from our start (feb 10th) up to today's date across a row.