Post reply

MAKE DIFFERENT COLOR IN CHART

  • March 6, 2016 at 12:52 am

    #325348

    Good Morning All,

    I would like to differentiate with different color for each value in CHART.

    eg : table have city and price details column

    city price

    ------------

    city1 200

    city2 300

    city3 400

    using column chart i would like to display city1 as different color , city2 as different color and so on..

    how to achieve it..?

    Kind Regards,

    Kannan.

  • March 6, 2016 at 2:34 am

    #1863360

    In the designer, click the cell you want to affect, click the color (or background color) property in the properties window, then enter a formula such as the one below:

    =Switch(Fields!City.Value = "city 1", "Red",

    Fields!City.Value = "city 2", "White",

    Fields!City.Value = "city 3", "Blue",

    true, "Orange")

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • March 6, 2016 at 2:50 am

    #1863361

    thank u :-):-)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply