How to change color of column in column chart using asp.net?

Pls adviceme to change color of each column in column chart

Below code works fine in only one color. I have 12 month. How to change the color of each month

Pls advice me

Thank you.

maideen

this is my code

Public Shared Function LoadTotalQR_Month() As List(Of Object)
Dim query As String = "SELECT SUM(AMOUNT) AS AMOUNT,MonthName,monthno FROM [dbo].[DP_Receipt_Head] " &
"WHERE YEARNO = @YearNo Group BY MonthName,monthno order by Monthno"
Dim constr As String = ConfigurationManager.ConnectionStrings("ConnectString").ConnectionString
Dim CharData_AREA As New List(Of Object)()
CharData_AREA.Add(New Object() {"MonthName", "AMOUNT"})
Using con As New SqlConnection(constr)
Using cmd As New SqlCommand(query, con)
cmd.Parameters.AddWithValue("@YearNo", Date.Today.Year)
con.Open()
Using sdr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
While sdr.Read()
CharData_AREA.Add(New Object() {sdr("MonthName"), sdr("AMOUNT")})
End While
End Using
Return CharData_AREA
End Using
End Using
Function

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Ho Maideen Keder,

Please check this link which will help you,
https://www.aspforums.net/Threads/442067/Google-Column-Chart-Change-Bar-color-based-on-condition-in-ASPNet/
0
maideen kader6y ago
Hi Salman

thanks for prompt Reply.
But I am using google chart , currently working fine. but i need column with colors of each month
pls advice me

Thank you
0
Salman Beg6y ago
Follow this link, https://stackoverflow.com/questions/15245141/how-to-change-the-colors-of-bars-in-column-chart-in-asp-net
0