set chart area background color based on x-axis and Y-axis value [Answered]RSS

• • Reply
  Joydev

  Member

  2 Points

  13 Posts

  set chart area background color based on x-axis and Y-axis value

  Jun 07, 2016 06:56 AM|Joydev|LINK

  I am creating a report that shows a scatter chart. I want to set the chart area in two colors based on x axis and y axis value.

  x-axis-1 to 10

  y axis-1 to 10

  area between x axis value 0 to <=5 and y axis 0 to <=5 set to pink

  area between x axis value >5 to <=10 and y axis >5 to <=10 set to green.

• • Reply
  Cole Wu

  Contributor

  2570 Points

  501 Posts

  Re: set chart area background color based on x-axis and Y-axis value

  Jun 08, 2016 09:24 AM|Cole Wu|LINK

  Hi Joydev,

  Joydev

  I am creating a report that shows a scatter chart. I want to set the chart area in two colors based on x axis and y axis value.

  As far as I know, it seems that we couldn't set chart area background color based on x-axis and Y-axis value, but we could set background color via field value. like this:

  =IIF(Fields!MRNumber.Value<5,"Pink","Green")

  For more information, please refer to:

  https://www.simple-talk.com/sql/reporting-services/sql-server-reporting-services-basics-customizing-ssrs-reports/

  http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/116006/

  Best regards,

  Cole Wu

• • Reply
  Joydev

  Member

  2 Points

  13 Posts

  Re: set chart area background color based on x-axis and Y-axis value

  Jul 07, 2016 06:28 AM|Joydev|LINK

  Got solution for this question.

  First we need to create a image as required by our report in paint. Save it as png format. Then add it to the report.

  Select the chart area in the chart ,then in properties box in the background image add the image you added.