Hello - I would like to create two charts from the contents of a single pivot table based on the year field.

This is the data i have

col1 | col2 | year
1 | 3 | 2008
2 | 7 | 2008
3 | 6 | 2007
4 | 5 | 2007

chart A should depict data representing only year values = 2008
chart B should depict data representing only year values = 2007

Please let me know whether this is possible and any guidance as to how to do it if possible. Also I would like to mention that creating two pivot tables is not an option I can consider.

Thanks