How to change chart point color based on other vallue in datasource

Hello williecg,

I don't know about “net 4 charts”, but since you didn't get an answer, this is how I would do it in other charting tools.

Instead of changing the colours of points, create a new series for each group you want to represent. Each series can have a different marker and different marker colours. Although many charting tools allow to manipulate individual points, it's generally easier to work with entire series. But I can't help you with the details of the manipulations...

(°v°)

Hi Cgee,

Not sure I understand all of what you are saying but assume you are grabbing the data from a database of some sort.

So something like this might work


Dim dataSource As SqlDataSource = New SqlDataSource(connectionString, selectSql)
Dim view6 As Data.DataView = dataSource.Select

            With Chart1.("Series1")
                For i = 0 To .Points.Count
                    If view6.Rows(i).columns(intColumnWithAgesIn).values >= 60 Then
                        .Points(i).Color = Color.Green
                    End If
                Next
            End With

harfang:

Thanks that is the "general case" solution. i did not think about it because I was actually thinking of the special case where I want to highlight only one data point in a series.

If I can't get some Net 4 action going here, I will implement your suggestion.  

I am not a pro and my frame of reference in charting in ms excel.

PrisonBroken:

It is a database with records containing the data elements I mentioned.

Actually, it is a database containing a whole bunch of other stuff.  I made up the example so the business problem details I am trying to solve do not get in the way of this learning opportunity.

If I get the answer to this question, I can extend it to my "real" problem.

Thanks Pros,

Cgee

Ah I read net 4 as asp.net 4 charting object is that not the case as that what the "example" I gave relates to.

Cheers

PrisonBroken:

asp.net 4 charting object

yes

Cgee

Thats what I am talking about. I knew there had to be a way to operate on an individual data point, I just do not have the detail knowledge to put it together without a map.

Thanks for hanging in there.

Cgee