When selecting columns for the X & Y-axis under Chart Options, you may not see the column you would like to plot on either axis. Each axis of a chart is either a Category or Value axis–both has constraints on what data it can plot.
- The Category Axis can plot any type of information, quantitative or text.
- The Value Axis can only plot quantitative data. It cannot plot date/time data, numbers in choice columns, or numbers saved as text.
Refer to the chart type-specific article for details on which axes are category or value. Consult SharePoint list settings for details on column types.