Need to create a comarative multi line chart

[BillJB]

I have a data table of Prices and dimensions Grouped By locations.Each Location has a different number of objects to show. I am trying to create a chart to compare the different groups. This chart is currently in Excel. We are trying to convert all reports to Crystal Reports. (XI R2).
I have tried two different charts, Line and XY scatter. The Scatter Shows the data as it is But it will not group by location. When I try the Line chart It keeps trying to Summarize.

Thank for any assistance
Bill

 

[BillJB]

Missing Information:
I forgot to iclude that the chart is comparing the price and then dimension of each Item grouped by the location. The data is from SQL server Stored procedure
Bill