The chart to the right is a 2D Column chart that groups each person’s actual sales and target amount. ... If you don’t know how to insert a chart, do the ... How to overlap two series in Excel.