The text above the X axis is called the horizontal (category) axis label. You only need to select the corresponding data, and it will be automatically generated. If it is not automatically generated, it can be added in the background. Add method: select the chart, right-click the data, click the row edit below the horizontal (category) axis label, and then select the corresponding cell range.

The data structure determines the chart type, and whatever chart type is needed will be adjusted to the corresponding data structure.

For example, the data structure 1/ chart 1 is as follows:

For example, data structure 2/ chart 2 is as follows:

Then fill in your own colors as needed.