Using Gallery Controls in Excel 2007:-

The charting tools ribbons contain many instances of a new Office interface element known as a gallery. A gallery control allows you to scroll through options one row at a time or click the open gallery button to see all the choices at one time. For example, the Chart Layouts gallery starts by showing three of the available icons: There are three control icons on the right side of the gallery. The up and down arrow icons allow you to move through the gallery one row at a. You can see this from the figure (given below).



(To effectively use the Gallery control, you use the three controls along the right side of the gallery.)

A quick trick is to use the bottom control icon, the More icon. You can click the More icon to cause the gallery to open the entire control, as shown in the Figure (given below).



(When you click the More icon, you can quickly see all choices in the gallery at one time.)