cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 168
Hi,
Could someone help me with code to turn every possible series trendline blue in a pivotchart. I have an automated process that builds charts and for some reason with missing series sometimes trend line changes color. I only have one trendline but I think k its when the series changes due to a missing series that it changes color. So i just wanted to write something to change them all to blue knowing there will only be one.
Any help is greatly appreciated.
Could someone help me with code to turn every possible series trendline blue in a pivotchart. I have an automated process that builds charts and for some reason with missing series sometimes trend line changes color. I only have one trendline but I think k its when the series changes due to a missing series that it changes color. So i just wanted to write something to change them all to blue knowing there will only be one.
Any help is greatly appreciated.