To create a column chart, I will select the data, click "Insert," and choose the "2D Clustered Column" option. This produces a neat chart that is easy to read. As useful as this is, I now want to ...

The Clustered Bar will appear on the ... will switch to the vertical axis, and the other columns will switch to the legend entry on the chart. Right-click the Target data series and choose Format ...

Select all the data in your table, including the headings, and click "2D Clustered Column Chart" in the Insert tab on the ...