I created the pivot table 1st, then created the chart from it, choosing to put it in a separate worksheet.