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
Bookmarks