EXCEL GRAPHING AND CHARTING: BAR CHART DATA SOURCE BOX

 Data Source boxes are used to manipulate the data, chart, format the axis, and for many other important tasks. To find the dialog box Select Data Source to switch axes, select the chart and follow this process:

1. Right-click > Select Data.

The dialog box “Select Data Source” pops up.

2. On the left, the three data series of three departments are shown. On the right, the horizontal axis labels are shown.

3. If Switch Row/Column is clicked, there will be five data series (2016, 2017,2018, 2019, and 2020) and three horizontal axis labels (three departments ).

Result:

You may change the style of your Bar Chart by clicking “Style”