Post reply

Changing Chart Area Color Based on X-Axis values

  • September 14, 2015 at 9:11 am

    #321153

    I have this below scenario for you.

    I have a requirement where in a Stacked Chart I need to shade the chart area behind the bars based on the values in the x-axis. Below is the example to illustrate the problem even better.

    I have 5 categories Category 1 to Category 5 so the chart area behind the bar for Category 4 and 5 should be colored as grey as they belong to the same group and for the others it should be as is. A picture for this condition has been attached.

    I have also looked at this link and as it says it is not possible,

    https://social.msdn.microsoft.com/forums/sqlserver/en-US/e0ab48bb-6ced-451a-aced-45797caa4baa/ssrs-and-color-area-on-chart-based-on-xaxis-value

    Would like to hear back from you all. Is there any standard feature to resolve this? If not is there any other workaround for this?

  • September 14, 2015 at 9:59 pm

    #1826589

    I cannot see any way to do exactly what you are after but perhaps a compromise might be to set the border colour for you series ?

  • September 16, 2015 at 7:07 am

    #1827048

    Thanks for your comments but unfortunately coloring the borders was not an option, as this idea was already rejected since it was having visual problem for the end-users.

    How ever since the category 4 and 5 was static, I was able to handle this by adding strip lines across the x-axis, this made the color of in the back of category 4 and 5 appear shaded.

    But I am still not able to get how to handle this scenario if the values in the x-axis is dynamically.

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

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