vbaamateur
New Member
- Joined
- Mar 16, 2022
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Amateur to VBA and need some help in creating some automated graphs for work.
I ideally need a macro command to delete any existing graph on the page and for a new graph to be created at the same time, for when data is updated within the table. I am comfortable in creating the command button but unsure on how to code for the task.
The image is a dummy of the way the data is laid out - various project numbers with underlying tasks being started and completed in different years. I need this to show on a clustered bar chart with years along the X-axis and task and project along the Y-axis. I need this to also show the length of time i.e the bar for Task 1 will start in 2020 and run until 2030, with all bars for all tasks.
I'd really appreciate a swift response on the below if there are any VBA wizzes out there!
I ideally need a macro command to delete any existing graph on the page and for a new graph to be created at the same time, for when data is updated within the table. I am comfortable in creating the command button but unsure on how to code for the task.
The image is a dummy of the way the data is laid out - various project numbers with underlying tasks being started and completed in different years. I need this to show on a clustered bar chart with years along the X-axis and task and project along the Y-axis. I need this to also show the length of time i.e the bar for Task 1 will start in 2020 and run until 2030, with all bars for all tasks.
I'd really appreciate a swift response on the below if there are any VBA wizzes out there!
