All,
I have a sheet in which in column A contains the all the dates of 2019. In columns B and C calculations are automatically performed when data for that day is available from an external database. If no data is available (e.g. tomorrow; 21-3-2019) the cell will be left blank using an IF function.
Column A | B | C |
1-1-2019 | 5 | 3 |
2-1-2019 | 5 | 4 |
3-1-2019 | 2 | 4 |
... | 2 | 2 |
20-3-2019 | 3 | 1 |
21-3-2019 | | |
22-3-2019 | | |
For reporting purposes I would like to make graph with YTD results every week. Does anyone know a way to have a dynamic x-axis selecting the cells from 1-1-2019 untill today (in this case 20-3-2019)? In this way I don't have to update the data in this graph every week.
Thanks!
I have a sheet in which in column A contains the all the dates of 2019. In columns B and C calculations are automatically performed when data for that day is available from an external database. If no data is available (e.g. tomorrow; 21-3-2019) the cell will be left blank using an IF function.
Column A | B | C |
1-1-2019 | 5 | 3 |
2-1-2019 | 5 | 4 |
3-1-2019 | 2 | 4 |
... | 2 | 2 |
20-3-2019 | 3 | 1 |
21-3-2019 | | |
22-3-2019 | | |
For reporting purposes I would like to make graph with YTD results every week. Does anyone know a way to have a dynamic x-axis selecting the cells from 1-1-2019 untill today (in this case 20-3-2019)? In this way I don't have to update the data in this graph every week.
Thanks!
