Hi forum,
Hoping you guys can assist and resolve this issue I've had for a while. Every month I receive data with three columns. Col1 is hourly segments so a maximum number of rows of 672 for 28 days, 696 for 29 days, 720 for a 30 day month and 744 for a 31 day month. There may occasions when a hour segment is missing if there is an issue in collecting the data.
I need to create 5 charts using Col 1 (dd/mm/yyyy hh:mm format with 2 spaces between data and time) and Col2 for each week in the month with each week starting on the Mondays in the month e.g.
week 1 01/08/2019 00:00 to 04/08/2019 23:00 (4 days)
week 2 05/08/2019 00:00 to 11/08/2019 23:00 (7 days)
week 3 12/08/2019 00:00 to 18/08/2019 23:00 (7 days)
week 4 19/08/2019 00:00 to 25/08/2019 23:00 (7 days)
week 5 26/08/2019 00:00 to 31/08/2019 23:00 (6 days)
I need to create another 5 charts using Col 1 and Col3 for each week in the month with each week starting on the Mondays. Ranges as above.
<tbody>
</tbody>
This data is received monthly so I want to remove the need to hard code the cell ranges required to create the 5 separate charts. How do you add dynamic ranges to create charts? Is there another solution? Is VBA required?
Advice on how I could do this would be appreciated.
Hoping you guys can assist and resolve this issue I've had for a while. Every month I receive data with three columns. Col1 is hourly segments so a maximum number of rows of 672 for 28 days, 696 for 29 days, 720 for a 30 day month and 744 for a 31 day month. There may occasions when a hour segment is missing if there is an issue in collecting the data.
I need to create 5 charts using Col 1 (dd/mm/yyyy hh:mm format with 2 spaces between data and time) and Col2 for each week in the month with each week starting on the Mondays in the month e.g.
week 1 01/08/2019 00:00 to 04/08/2019 23:00 (4 days)
week 2 05/08/2019 00:00 to 11/08/2019 23:00 (7 days)
week 3 12/08/2019 00:00 to 18/08/2019 23:00 (7 days)
week 4 19/08/2019 00:00 to 25/08/2019 23:00 (7 days)
week 5 26/08/2019 00:00 to 31/08/2019 23:00 (6 days)
I need to create another 5 charts using Col 1 and Col3 for each week in the month with each week starting on the Mondays. Ranges as above.
Col1 | col2 | Col3 |
01/08/2019 00:00 | 2345 | 343 |
01/08/2019 01:00 | 4355 | 543 |
01/08/2019 02:00 | 4436 | 654 |
01/08/2019 04:00 | 4443 | 456 |
01/08/2019 05:00 | 7557 | 643 |
01/08/2019 06:00 | 4346 | 435 |
down to | ||
31/08/2019 23:00 | 4665 | 469 |
<tbody>
</tbody>
This data is received monthly so I want to remove the need to hard code the cell ranges required to create the 5 separate charts. How do you add dynamic ranges to create charts? Is there another solution? Is VBA required?
Advice on how I could do this would be appreciated.