MSChart: Change Colum Colors 1

[RoguePoet01]

Hi,

I'm using MSChart in a form, and column one is always red.

I'd like to change it to dark blue, because it would go better with the background.

Does anybody know the code for this?

Thanks.

 

[SkipVought]

RoguePoet01,

It ought to be something like...

MyChart.Series(SeriesNbr).Interior.Color = vbBlue

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[RoguePoet01]

I appreciate the effort, Skip - I was able to Google this, and it works. Now I just need to change the background color!


With Form1.ch1
.ColumnCount = 1
.Column = 1
.ColumnLabel = "BF"
.ChartType = 3
.ChartType = 1 ' BAR
' .ChartType = 3 ' LINE
Do
.RowCount = j
.Row = j
.RowLabel = Format(rs.Fields(1).Value, "mmm/dd")
.Column = 1
.Data = rs.Fields(2).Value
j = j + 1
rs.MoveNext
Loop Until rs.EOF
With .Plot
.Axis(VtChAxisIdY).ValueScale.Auto = False
.Axis(VtChAxisIdY).ValueScale.Maximum = 2.5
.Axis(VtChAxisIdY).ValueScale.Minimum = 1.25
.SeriesCollection(1).DataPoints(-1).Brush.FillColor.Red = 250
.SeriesCollection(1).DataPoints(-1).Brush.FillColor.Blue = 0
.SeriesCollection(1).DataPoints(-1).Brush.FillColor.Green = 0
End With
End With

 

[SkipVought]

You should have ChartArea & PlotArea

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884