Excel VBA Series Automatic Color

B

bradleyoung

Joined
Apr 13, 2009
Messages
1
Reaction score
0
In one of my macros, I'm trying to add a new series to an existing chart. I want the new series to have the same formatting as an existing series - so it looks the same, but it doesn't affect trendlines. My macro works just fine if the existing series has been custom formatted by the user. However, if it hasn't and just has the automatic colors that are defaults to excel. Is there anyway to get the color of a series that has a color of 57 (auto picked)?

Thanks!

Brad
 
Back
Top