Plotting different chart types

In the Select Data page, the Category (X) Series, or Category Definition, option plots data on the x-axis. The value series option plots data on the y‑axis. The options differ slightly in name and function, depending on the chart type. For example, when you create a meter chart, which has no axes, you define the position of a needle on the dial instead of defining a y-axis. When you create a pie chart, you define the size of the slices instead of the y‑axis. Table 16‑1 describes the differences in plotting options in the Select Data page for chart types.

Table 16‑1 Differences in x- and y-axis plotting options for chart types
Chart type	Option name	Description
Area, bar, cone, difference, line, pyramid	Category (X) Series	Arranges data on x-axis. Can group, sort, and aggregate data.
Area, bar, cone, difference, line, pyramid	Value (Y) Series	Plots values on y-axis.
Bubble	Category (X) Series	Plots values on the x-axis. Can group, sort, and aggregate data.
Bubble	Y Value and Size	Plots values on y-axis and defines the size of the bubbles.
Meter	Category Definition	Requires a blank string " ": quotation mark, space, quotation mark.
Meter	Meter Value Definition	Defines values of the dial and position of the needle. Creates multiple meters.
Alternate meter subtype	Category Definition	Requires a blank string " ": quotation mark, space, quotation mark.
Alternate meter subtype	Meter Value Definition	Defines values of the dial and position of the needle.
Pie	Category Definition	Defines what slices represent.
Pie	Slice Size Definition	Defines size of sectors. Creates multiple pies.
Scatter	Category (X) Series	Plots markers along x-axis. Groups data along x-axis.
Scatter	Value (Y) Series	Defines intersection of (x-y) value pairs. Defines multiple (x-y) value pairs.
Stock	Category (X) Series	Plots values along x-axis.
Stock	Value (Y) Series	Defines four levels of data: high, low, open, close. Defines multiple sets of candlesticks.