Using the Expand Icon to Access a Gallery of All Chart Types in Excel 2007:-

A dialog launcher icon appears in the lower-right corner of some ribbon groups. This icon usually allows you to bypass the ribbon and head straight to a legacy-style dialog box. Figure (given below) shows the expand icon for the Charts group. Clicking this icon leads to a dialog box that shows all 73 charting types in one place.



(You can click the dialog launcher icon to bypass the ribbon and open a charting dialog box.)