Select the data. Click the Insert tab. Click the Charts Dialog Box Launcher. In the Insert Chart dialog box, select the chart type and chart subtype. Then click Set as Default Chart.