What Is The Category Axis In Excel

Chart Elements

The title is a text box you can place anywhere on the nautical chart.

The plot is the area on the chart that displays the information in the chart type you lot cull.

A data point is one piece of information appearing on the chart. For most chart types, each information signal shows the value of the contents of one prison cell in the information range linked to the chart.

A nautical chart's fable shows what kind of data is represented in the nautical chart. By default, the text that appears in the fable is taken from the chart's data range.

Series are sets of related data. A chart tin can have one or more series. Each chart blazon displays series differently. Often (but not e'er), serial correspond to rows of data in the data range.

Categories are "bins" into which the data from each series is sorted. Frequently (but not always), categories stand for to columns of information in the information range.

For information on series and categories, encounter Headings in the Data Range and How Each Nautical chart Type Displays Series and Categories.

The Y axis is vertical on virtually charts (except for bar charts, where the Y axis is horizontal). Because it displays values, the Y axis is also chosen the value centrality. On XY and bubble charts, both the X and Y axes are value axes.

The Ten axis is horizontal on most charts (except for bar charts, where the 10 axis is vertical). On most charts, the Ten centrality is called the category centrality considering it displays category names.

Axis labels are words or numbers that mark the different portions of the axis. Value axis labels are computed based on the data displayed in the chart. Category axis labels are taken from the category headings entered in the chart'south data range.

Axis titles are words or phrases that describe the entire centrality.

Markers identify data points. Y'all can put markers on all data points in a series or on simply selected data points.

Grid lines are horizontal or vertical lines that extend from the axis ticks.

Drop lines are lines leading from a information betoken to the category axis. On large or complex charts, drop lines assistance show which category a data betoken belongs to. Drop lines are only available on line chart types.

Data labels identify individual data points. Data labels are a good way to emphasize or explain a item piece of data on the chart. Data labels tin brandish the information point'due south category, its value, or text you enter yourself.

Ticks are curt lines that mark off an centrality into segments of equal size. On value axes, centrality labels are displayed on ticks. On category axes, axis labels are displayed between ticks.

Label lines are lines leading from a information bespeak to its data label.

Loftier-low lines are used on stock charts to prove the range of prices the stock allowable over a period of time. High-low lines are available only on line nautical chart types.

Open-shut bars are used on stock charts to evidence the stock's price at market opening and closing. You can color the confined differently to show whether the stock gained or lost.

Studies are sub-charts that display beneath the main chart in the aforementioned plot area. Studies share the same X centrality and usually evidence similar data on a different scale. Stock charts often display studies that evidence the volume of stocks traded. You lot can display one or more studies on any chart that has axes.