amethystia
New Member
- Joined
- Apr 21, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
I have about 20 line charts with >30 series in each one which I want to colour based on cells in one of tabs, like this:
So I am trying to use VBA to pick up the line and marker properties for each of the series above, but for the life of me I can't find a way to make it go from changing the formatting of series 1 to move to series 2 etc.
This is the code I have used as a basis: Excel Chart VBA - 33 Examples For Mastering Charts in Excel VBA and some code I recorded when changing marker settings. I couldn't find something similar in past threads.
Any suggestions?
I have about 20 line charts with >30 series in each one which I want to colour based on cells in one of tabs, like this:
So I am trying to use VBA to pick up the line and marker properties for each of the series above, but for the life of me I can't find a way to make it go from changing the formatting of series 1 to move to series 2 etc.
This is the code I have used as a basis: Excel Chart VBA - 33 Examples For Mastering Charts in Excel VBA and some code I recorded when changing marker settings. I couldn't find something similar in past threads.
Any suggestions?