move the chart select the range a4:f11. use the quick analysis feature to create a clustered column chart. move the chart to a sheet named annual attendance chart. to a sheet named annual attendance chart..

Ribbon1. Select cells A4:F11 and then click the Insert tab.2. In the Charts group, click the Column button, and under the 2-D Column, click Clustered Column.

What is clustered column?

Ribbon (2)

1. Select cells A4:F11, and then click the Insert tab.

2. In the Charts group, click the Create Chart Dialog Box Launcher (or click any of the chart buttons, and then All Chart Types).

3. In the Insert Chart dialog box, in the right pane, under Column, click ClusteredColumn (first item), and then click OK. Alternatively, in the right pane, double-click Clustered Column.

Keyboard

1. Select cells A4:F11, press ALT (or F10 or press F6 two times), N, and then C.

2. In the Gallery, with Clustered Column selected (first item), press ENTER.

Keyboard (2)

1. Select cells A4:F11, and then press ALT (or F10 or press F6 two times), N, K (or press C (or N, or Q, or B, or A, or D, or O), and then A (or TAB or ARROW to select All Chart Types and press ENTER (or SPACEBAR))).

2. In the Insert Chart dialog box, press TAB to move to the chart-type gallery, use the arrow keys to select Clustered Column (first item), if necessary, and then press enter.

Keyboard (3)

1. Click the Name box, type A4:F11, and then press ENTER. Alternatively, select the range A4:F11. Press ALT+F1.

The default column chart behavior is a clustered column chart, in which data from every series are shown near to one another at the same category axis value.
A sort of graph used to compare data sets is a clustered column chart.
They are ideal for categorizing data and helping to see it. Clustered column charts are frequently used to compare sales statistics or other time-varying data.
A clustered column chart shows multiple data series in clustered vertical columns.
Vertical bars are organized by category because all data series have the same axis labels.
Clustered columns make it possible to compare many series directly, but they rapidly become overly complicated visually.

To learn more about clustered columns refer to:

https://brainly.com/question/25807912

#SPJ4