Excel VBA Series Automatic Color

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top