In excel charts, what is the horizontal x-axis usually used as

In excel charts, the horizontal x-axis is usually used as the "category axis". When using excel to make a chart, it is generally divided into an X-axis and a Y-axis. The X-axis shows the classification of the data, while the Y-axis shows the data.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2016 version, Dell G3 computer.

Related learning recommendations: excel tutorial

When using excel to make a chart, it is generally divided into an X-axis and a Y-axis. The X-axis shows the classification of the data, and the Y-axis Axes display data.

Specific example:

Create a blank excel file and double-click to open the file

Select In some cells of the table, merge cells

On the right side of the merged cells, add two rows of data, divided into quarter and quantity

Select the added data, then click the Insert menu, select the histogram template

Click OK to insert the histogram, and then adjust the width and height of the histogram

Select the histogram, modify the background color of the graph, and then set the related attributes and styles of the histogram columns; you can find that the horizontal x-axis displays the quarter, which is the category axis

To read more related articles, please visit PHP Chinese website! !

The above is the detailed content of In excel charts, what is the horizontal x-axis usually used as. For more information, please follow other related articles on the PHP Chinese website!