<div>
Version 2007.<br />
<br />
Thanks for pointing me to what I should have found in the object.<br />
<br />
I'm not sure themecolor is correct as when I test this its zero for a chart where I've manually colored the segments.<br />
<br />
SchemeColor, however has values. &nbsp;I'm trying to relate a set of cells that are colored with the chart line segments. &nbsp;What's the relationship with <br />
a range.interior.color or .colorindex with schemecolor (or other related color property I should be using)?<br />
<br />
Thanks,<br />
<br />
Dave
</div>


Version 2007.

Thanks for pointing me to what I should have found in the object.

I'm not sure themecolor is correct as when I test this its zero for a chart where I've manually colored the segments.

SchemeColor, however has values.  I'm trying to relate a set of cells that are colored with the chart line segments.  What's the relationship with
a range.interior.color or .colorindex with schemecolor (or other related color property I should be using)?

Thanks,

Dave

<div>
Accurate enough for me to get to the correct property I needed...
</div>


Accurate enough for me to get to the correct property I needed...

<div>
<div class="content wysiwyg-content">
I know how to color the whole line, and I have a routine that enumerates the points. &nbsp;What is the property I can update to change a single segment at a certain point in a line chart?<br />
<br />
Dave
</div>
</div>


I know how to color the whole line, and I have a routine that enumerates the points.  What is the property I can update to change a single segment at a certain point in a line chart?

Dave

Excel VBA approach to color a segment in a line chart

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.