I have done the same. Created a chart by using the table the pivot table - works well.