Tried your case in a simple workbook. Switching ITEM and YEARS in
Pivot Rows and Columns produces changes to the chart. This is a simple
move in a Pivot Table Layout. However YEARS become X and not Y as you
mention. Try how it works for you.
--
Tomek Polak, http://vba.blog.onet.pl