Custom Coloring an area chart with VBA

**mattdick** · 06-05-2009, 06:13 PM

For the life of me I can not find the attributes for coloring a data series in an xlAreaStacked chart.

Code:

  Charts.Add
    ActiveChart.SetSourceData Source:=Range("E3").Resize(4, DateOffset + 1)
    ActiveChart.SeriesCollection(1).XValues = Range("F1").Resize(1, DateOffset + 1)
    ActiveChart.ChartGroups(1).GapWidth = 0
    ActiveChart.ChartType = xlAreaStacked

I'm quite sure it's something like:

ActiveChart.ChartType.DataSeries(1).Color = "#FFFFFF"

but it seems suspiciously and strangely impossible a piece of information to find.

Thanks for any help.

**starryknight64** · 06-05-2009, 06:53 PM

Try this out:

Code:

ActiveChart.SeriesCollection(1).Interior.ColorIndex = 32

**mattdick** · 06-05-2009, 07:22 PM

Super, you rock.

I used that as a keyword which finally led me to intelligible discussions of excel color and found that ColorIndex is the less subtle cousin of Color, which I am now using:

Code:

ActiveChart.SeriesCollection(1).Interior.Color = "#FF0088"

Thanks!

**starryknight64** · 06-06-2009, 03:08 AM

Awesome! Glad I could help.

I assume this is solved now?

**mattdick** · 06-06-2009, 12:24 PM

Yes, totally solved. I am using Color instead of ColorIndex, but you helped me find the real resource I needed.

Thread: Custom Coloring an area chart with VBA

Thread Tools

Display

Custom Coloring an area chart with VBA

Re: Custom Coloring an area chart with VBA

Re: Custom Coloring an area chart with VBA

Re: Custom Coloring an area chart with VBA

Re: Custom Coloring an area chart with VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions