How to assign color theme on FALSE

[dluhut]

Hello Excel Gurus,

Traditionally, when we create a chart in Excel, Excel automatically assign color for each series and I believe this is via MS Excel Office Color Themes.

What I'm trying to do here is that I'd like to assign a specific color for each string/series. However, the string types (series) may change as time grows. Thus, if there's 'new' string/series that wasn't account for, I'd like macro to automatically assign color like the traditional way based on the number of 'new' strings/series.

The logic goes like this:

If string/series = "A", then assign color [Red] else
If string/series = "B", then assign color [Blue] else
assign color theme for each string/series.

Is it doable? If so, what's the syntax for macro to assign automatically assign color based on the number of string/series that I didn't account for?

Thank you!

[dflak]

Here is my shot at it. Create a table called Table_Chart_Color with the column title series as shown. Fill in the Series Names and then fill in the cell with the desired colors.

Change the test macro to match the sheet name and the chart name

Please Login or Register  to view this content.

Run this code.