How to create a YOY comparison chart using a PivotChart in Excel Your email ... choose Line in the list to the left, and click OK. Figure F shows the two pivot objects side by side.