Dimitris254
Board Regular
- Joined
- Apr 25, 2016
- Messages
- 139
I'm using a macro to make a chart in Excel, and i define the colors by:
instead of a specific name, how could i define the collection's color by referencing the cell?
does not work
Rich (BB code):
myChart.SeriesCollection("Services").Interior.Color = RGB(...)
instead of a specific name, how could i define the collection's color by referencing the cell?
Rich (BB code):
myChart.SeriesCollection("B1").Interior.Color = RGB(...)
does not work