Hugo huijer
Member
Hi chandoo,
I have a dashboard tool, where data gets entered via userforms, and gets transferred to datatables. The first column of the datatables are the dates, with every date given a single row.
My dashboard shows specific data from this table in a chart. I have 2 dropdown lists in a cell (via validation) in which a user can select a start & end date. I want my charts to be dynamic according to these cell values.
I guess this can either be done with sorting the datatable according to these dates, or adjusting the chart's x-axes (the date) according to these dates.
What should I do, and how can I do this?
Thanks alot!
I have a dashboard tool, where data gets entered via userforms, and gets transferred to datatables. The first column of the datatables are the dates, with every date given a single row.
My dashboard shows specific data from this table in a chart. I have 2 dropdown lists in a cell (via validation) in which a user can select a start & end date. I want my charts to be dynamic according to these cell values.
I guess this can either be done with sorting the datatable according to these dates, or adjusting the chart's x-axes (the date) according to these dates.
What should I do, and how can I do this?
Thanks alot!