Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 451
- Office Version
- 365
- Platform
- Windows
I have sent this query in before but I'm not sure I have explained it very well.
I have a clustered stacked column chart but the length of the Y series is variable and can be hundreds (X series is static)
I want to see if there is a macro that can remove all the existing series and add the new series however long it is every time I need to change the chart.
My Y series values starts in Cell B7:AH7 with the Series Name in B7 (always the starting Cell).
I think I need the variable to do an end and end up on the row B to see the end row the number of series' needs to go to.
My Chart is called Chart 8 and is in the sheet called Cluster Graph
Can anyone help me with a macro that can do the above?
Your help is really appreciate.
One of the your team did help me with a renaming of Legends in a chart which was really successful.
As always thank you for your time.
I have a clustered stacked column chart but the length of the Y series is variable and can be hundreds (X series is static)
I want to see if there is a macro that can remove all the existing series and add the new series however long it is every time I need to change the chart.
My Y series values starts in Cell B7:AH7 with the Series Name in B7 (always the starting Cell).
I think I need the variable to do an end and end up on the row B to see the end row the number of series' needs to go to.
My Chart is called Chart 8 and is in the sheet called Cluster Graph
Can anyone help me with a macro that can do the above?
Your help is really appreciate.
One of the your team did help me with a renaming of Legends in a chart which was really successful.
As always thank you for your time.