Software Version: Crystal Reports 10
I want to create a line chart based on a set of data. I need to firstly know if it's even possible... and secondly, if it is, how to do it.
I have attached an image of the sort of thing I'd like to do.
(I have a feeling that the multiple x-axis lines might be a problem, if it is I can work around it and put that information elsewhere on the report. The main issue is the setting of values for X/Y axis and the plotting of the line)
I would have all the data that appears on the graph to hand. I have no idea how to set the X and Y axis to the values provided to the report. i.e. Y axis from 6.0 - 7.2 in .1 segments and X axis from 1 - 8 with in 1 segments.
I would then have a y value for each x segment. e.g. Y1 = 6.5, Y2 = 6.4, Y3 = 6.5
Is that even how it works? If not, how does it work? I can't figure it out from the wizard. The only places I can input variables is the "On change of" and "Show values" sections, but not following what they are or how they work.
Do I need to manipulate the data and put it in a very specific way in order for the chart wizard to understand? How would I go about doing this given the example I've shown.
Sorry the questions are so vague, but I've never tried to do a chart in crystal before. I looked for some tutorials online but couldnt find much. If I'm not making sense, please ask for clarification.
Any help appreciated....