Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
X Axis Vs. Category Axis
Contents
[
Hide
]
Possible Usage Scenarios
There are different types of X axes. While the Y axis is a value-type axis, the X axis can be a category-type axis or a value-type axis. Using a value axis, the data is treated as continuously varying numerical data, and the marker is placed at a point along the axis that varies according to its numerical value. Using a category axis, the data is treated as a sequence of non‑numeric text labels, and the marker is placed at a point along the axis according to its position in the sequence. The sample below illustrates the difference between value and category axes.
Our sample data is shown in the sample table file below. The first column contains our X‑axis data, which can be treated as categories or as values. Note that the numbers are not equally spaced, nor do they even appear in numerical order.
Handle X and Category Axis Like Microsoft Excel
We will display this data on two types of chart: the first chart is an XY (Scatter) chart with X as a value axis, and the second chart is a line chart with X as a category axis.
The following sample code generates the output Excel file.
Sample Code