<div>
Yes, the following example assumes you have one chart inside your worksheet (not a separate sheet) and set color 3 (red) to the third point of every serires.<br />
<br />
Public Sub ChangeRowCol()<br />
&nbsp; &nbsp; Dim s As Series<br />
&nbsp; &nbsp; For Each s In ChartObjects(1).Chart.Seri<wbr />esCollecti<wbr />on<br />
&nbsp; &nbsp; &nbsp; &nbsp; s.Points(3).Interior.Color<wbr />Index = 3<br />
&nbsp; &nbsp; Next s<br />
End Sub<br />
<br />

</div>


Yes, the following example assumes you have one chart inside your worksheet (not a separate sheet) and set color 3 (red) to the third point of every serires.

Public Sub ChangeRowCol()
    Dim s As Series
    For Each s In ChartObjects(1).Chart.SeriesCollection
        s.Points(3).Interior.ColorIndex = 3
    Next s
End Sub



<div>
ermm i have to admit to not knowing how to implement your answer.<br />
<br />
I am using vb and have a chart called &quot;timechart&quot;, and it was 1 column, 5 rows. I want each of the five rows to be different colours. However the properties of a such a chart only allow you to change the colour of each series/column, and all bars within that series/column appear to have to be the same colour.<br />
<br />
If this is what your code does then great, but I'm not quite sure how it works.<br />
<br />
thanks,<br />
<br />
Adam
</div>


ermm i have to admit to not knowing how to implement your answer.

I am using vb and have a chart called "timechart", and it was 1 column, 5 rows. I want each of the five rows to be different colours. However the properties of a such a chart only allow you to change the colour of each series/column, and all bars within that series/column appear to have to be the same colour.

If this is what your code does then great, but I'm not quite sure how it works.

thanks,

Adam

<div>
<div class="content wysiwyg-content">
hey, the title says it all.<br />
<br />
I can change the &quot;series&quot; colour, which is technically the column, but is there any way of changing an individual row colour? i.e. 5 columns, 2 rows... and all 10 bars different colours??<br />
<br />
thanks very much,<br />
<br />
Adam Miles
</div>
</div>


hey, the title says it all.

I can change the "series" colour, which is technically the column, but is there any way of changing an individual row colour? i.e. 5 columns, 2 rows... and all 10 bars different colours??

thanks very much,

Adam Miles

Changing Row Color in MSChart Controls?!

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.