I need to draw a diagonal line in the chart from (1,1) to (5,5).
Based on your description, it seems that you want to draw a 45 degree reference line in the scatter chart, please check the following steps.
1. Add the field [Itemsold] into data region and pay attention to the value of field you added. Then right click the [Itemsold] field to open Series Properties pane and select the Axes and Chart Areas option. Select secondary for Value axis.
2.Select and right click the secondary axis, uncheck the Show Axis option.
3.Select and right the scatter plot which represents the field [Itemsold] you have ever added to data region. Then select Change chart type option, change the type to Line chart.
My first data region(scatter chart) display the profit made for itemsold with series as Product. When I follow your steps and add itemsold as 2nd data region ,the chart will automatically group by itemsold and series by Product. Because of this series(product)
I am not able to display the line. If I remove the Product series I am able to display the diagonal line But in this case it will not display all the dots for scatter chart.
Member
2 Points
13 Posts
ssrs- Draw a diagonal line in a chart
Jul 07, 2016 06:25 AM|Joydev|LINK
I have a scatter chart.I have to compare the itemsold with the
profit made for each product
Horizontal axis: Itemsold(in numbers)(1,2,3,4,5) interval=1
Vertical axis: Profit(in lakhs)(1,2,3,4,5) interval=1
chartdata:
Values : Profit
Category Group: Itemsold
series: Product
I need to draw a diagonal line in the chart from (1,1) to (5,5).
Please help me to achieve this.
Contributor
2570 Points
501 Posts
Re: ssrs- Draw a diagonal line in a chart
Jul 08, 2016 09:08 AM|Cole Wu|LINK
Hi Joydev,
Based on your description, it seems that you want to draw a 45 degree reference line in the scatter chart, please check the following steps.
1. Add the field [Itemsold] into data region and pay attention to the value of field you added. Then right click the [Itemsold] field to open Series Properties pane and select the Axes and Chart Areas option. Select secondary for Value axis.
2.Select and right click the secondary axis, uncheck the Show Axis option.
3.Select and right the scatter plot which represents the field [Itemsold] you have ever added to data region. Then select Change chart type option, change the type to Line chart.
Best regards,
Cole Wu
Member
2 Points
13 Posts
Re: ssrs- Draw a diagonal line in a chart
Jul 11, 2016 05:25 AM|Joydev|LINK
I am still not able to achieve it.
My first data region(scatter chart) display the profit made for itemsold with series as Product. When I follow your steps and add itemsold as 2nd data region ,the chart will automatically group by itemsold and series by Product. Because of this series(product) I am not able to display the line. If I remove the Product series I am able to display the diagonal line But in this case it will not display all the dots for scatter chart.
Please correct me if I am wrong.
Thanks,
Joy