How do I go about creating a vba macro that reads data from a sheet in order to create a chart? in the sheet below my test data is found in columns a,b with details in rows 2-8. However in the real data
my rows will be much more. Add a new sheet to insert the chart.
Thanks
my rows will be much more. Add a new sheet to insert the chart.
Thanks
Date | Color | ||||
1/1/2024 | blue | ||||
1/1/2024 | green | ||||
1/1/2024 | yellow | ||||
11/3/2023 | red | ||||
6/2/2023 | orange | ||||
6/3/2023 | orange | ||||
6/4/2023 | black | ||||
My Chart | |||||
Counts | |||||
4 | |||||
3 | 3 | ||||
2 | |||||
1 | 1 | 1 | 1 | 1 | |
Date | 6/2/2023 | 6/3/2023 | 6/4/2023 | 11/3/2024 | 1/1/2024 |