Creating chart from table with multiple series

[crevert2]

Hey,

I have a table that has costs of 3 sample products. Each month, the cost is recaclulated for the 3 parts and added to the end of the table. I want to create a chart for each part number showing how the cost has changed each month, but I don't know how to get the chart to choose just 1 product from the table that has all 3 products on it. I know I can manually select it but I would like it to automatically update when I add the new months data. Below is a sample table and chart. Is it even possible to do what I want or do I need to sort these into seperate tables?

Thanks!

 

[jondavis1987]

I would do a pivot chart and include product as a filter