Solution By Steps

Step 1: Define Range B3:E3

To define range B3:E3, click on the chart to select it. Then, go to the “Chart Design” tab in Excel. Click on “Select Data” in the Data group.

Step 2: Enter Range in Axis Labels

In the “Select Data Source” dialog box, under “Horizontal (Category) Axis Labels,” click on “Edit.” In the Axis Labels text box, enter the range B3:E3.

Final Answer

Range B3:E3 is entered as the Horizontal Axis Label values in the Stacked Column chart.

Key Concept

Horizontal Axis Label

Key Concept Explanation

The Horizontal Axis Label in a chart represents the categories or data points displayed along the horizontal axis. It helps in visually organizing and comparing data in a chart.