Splitting a data set into multiple lines on the same chart
I have a dataset similar to the following:
Type Price Year
AAA 1000 2011
BBB 1000 2011
CCC 1000 2011
AAA 2000 2012
BBB 4000 2012
CCC 6000 2012
I would like to create a report that shows three line graphs, one each for AAA, BBB, and CCC. I would like Price on the Y axis and Year on the X axis.
Is there a way to do this with a "Chart View" and without using SQL to create a separate data table?
Thanks in advance,
Jeff