Apple numbers User Manual
110
Chapter 6
Using Charts
Formatting the Value Axis
You can set the values and units to be displayed along the value axis, the axis on which
you read the data point values. For column charts (vertical bars), line charts, and area
charts, the Y-axis is the value axis. For horizontal bar charts, the X-axis is the value axis.
For scatter charts, both axes are value axes. (Pie charts don’t have a value axis. To read
about formatting pie charts, see “Pie Charts” on page 113.)
you read the data point values. For column charts (vertical bars), line charts, and area
charts, the Y-axis is the value axis. For horizontal bar charts, the X-axis is the value axis.
For scatter charts, both axes are value axes. (Pie charts don’t have a value axis. To read
about formatting pie charts, see “Pie Charts” on page 113.)
To format the value axis:
1
Select a chart.
2
Click Inspector in the toolbar, click the Chart Inspector button, and then click Axis.
3
To set the value at the chart origin, type a number in the Minimum field (under Value
Axis Format).
Axis Format).
The Minimum value cannot be higher than the minimum value of your entire data set.
4
To set the highest number displayed on the value axis, type a number in the Maximum
field.
field.
The Maximum value cannot be lower than the maximum value of your entire data set.
5
To specify the number of axis markings between the minimum and maximum values,
specify a number in the Steps field.
specify a number in the Steps field.
6
To display the minimum data value on the value axis, select Show Value Labels and
Show Minimum Value from the Labels, Ticks, & Grids X-Axis or Y-Axis pop-up menu,
depending on the chart.
Show Minimum Value from the Labels, Ticks, & Grids X-Axis or Y-Axis pop-up menu,
depending on the chart.
7
To specify units for axis values, under Number Format type text in the Prefix or Suffix
field (or choose a symbol from the pop-up menus).
field (or choose a symbol from the pop-up menus).
8
To display values on the value axis as logarithmic values, choose Logarithmic from the
X-Axis or Y-Axis pop-up menu, depending on the chart. This option is available only for
2D bar/column charts that aren’t stacked and for line charts. You can’t plot negative
values on the log axis.
X-Axis or Y-Axis pop-up menu, depending on the chart. This option is available only for
2D bar/column charts that aren’t stacked and for line charts. You can’t plot negative
values on the log axis.
9
To display values on the value axis of stacked charts as percentages, choose Percentage
from the X-Axis or Y-Axis pop-up menu on the Axis pane.
from the X-Axis or Y-Axis pop-up menu on the Axis pane.
For pie charts, you display values as percentages by choosing Show Pie Values as
Percentages from the Data Point Settings pop-up menu.
Percentages from the Data Point Settings pop-up menu.
Placing Labels, Gridlines, and Tick Marks
The X-Axis and Y-Axis pop-up menus in the Axis pane of the Chart Inspector provide an
array of options for placing tick marks, labels, and gridlines along the value axis or the
category axis. The options in these pop-up menus vary depending on the kind of chart
you select.
array of options for placing tick marks, labels, and gridlines along the value axis or the
category axis. The options in these pop-up menus vary depending on the kind of chart
you select.