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:
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.
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,
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:
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
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.