I have tried all possibilities and searched several forums but none of them specify in detail how to display percentage values in SSRS chart. I need to set min value, max value and the interval. If I do that, the chart does not plot my graph properly. This is my query
And the raw data.
Weekend TotalItems Pickedup on time Delivered on time
2014-05-24 00:00:00.000 2071 1000 600
2014-05-31 00:00:00.000 2440 800 1200
2014-06-07 00:00:00.000 2499 300 1600
2014-06-14 00:00:00.000 2662 1700 500
I need to show Total Items on Y-axis and WeekEnd on X-axis. Also I need to have secondary axis to show Pickedup On time and Delivered On time as line chart. To achieve this I am showing this on secondary axis and Total Items on primary axis. My problem is that if I set y-axis percentage properties (min value, interval etc), it displays the axis labels properly but does not plot the lines on the chart. If I do not adjust the label properties, it plots the lines on the chart but not using the correct values.
I have spent almost whole day researching this but of no use. Can someone please explain me clearly how do I prepare the data to display percentage value properly on the chart? Do I need to calculate those as percentages or decimal values or an express as pickedupontime/totalItems? The following is the chart I am expecting but the pickupontime/deliveredontime lines should be plotted properly.
Please let me know if you have any questions to solve this problem.