David Ku
Yes, it is possible to create a line chart in Crystal Reports that shows multiple products on the same chart. To do so, you need to create a group for each product, and then create a chart based on the groups.

To create the groups, go to the "Group Expert" window. In the "Group by" dropdown, select the "Product" field. In the "Options" tab, select the "Add a new group above" option, and then click "OK". This will create a new group for each product.

Next, create a chart based on the groups. Go to the "Insert" menu, select "Chart", and then select "Line". In the "Chart Expert" window, select the "Data" tab. Select the "Group Name" from the dropdown, and then select the "DateTime" and "Value" fields. Finally, click "OK" to create the chart.

Your line chart should now show multiple products on the same chart.

Thanks Yogananda, the results quite close but I still missed some tweaking. The P1 and P2 data is in column tag.

My chart object is in Report Footer (RF)

Group #1 tag created

My chart type is : Numeric Axis Line Chart so that the time data can show up on the X axis properly.

My chart looks like this and the P2 is missing. Only P1 shown...

My data set looks like this... assuming FE = P1 and NU = P2

I am not sure what exactly missing here.. What I want to achieve is something like this where I do it in Excel.

The column arrangement a bit different.

Any thoughts if it is possible in Crystal Report ?