**Formatting Chart Axes**

In column charts, area charts, line charts, and bar charts data points are plotted on one

axis (the y-axis for column, area, and line charts; the x-axis for bar charts) and data sets

are grouped on the other axis. The data point axis is called the *value axis,* and the data

set axis is called the *category axis*.

In scatter charts, both the x and y axes are value axes. In 2-axis charts, there are two

y axes—Value Axis (Y1) and Value Axis (Y2)—which can be formatted separately.

For more details about 2-axis charts, see “Customizing 2-Axis and Mixed Charts” on

page 157.

To show or hide an axis or chart borders, set the scale (linear or log) and span of the

value axis, or adjust grid and tick marks along the axes, make selections, and enter

appropriate values in the Axis pane of the Chart inspector.

Set the range of values that

appear on the chart grid.

Select units for values in

the chart.

Set attributes of labels,

tick marks, and more.

Show or hide axes and chart

borders (2D charts only).

**To open the Chart inspector:**Click Inspector in the toolbar (or choose View > Show Inspector) and click the Chart

m

inspector button.

**To place gridlines and tick marks along the chart axes:**Select the grid lines and tick marks you want from one or both of the Choose Axis

m

Options pop-up menus.

**To format the values along the value axis, do any of the following:**To set the highest number displayed on the value axis, type a number in the Maximum

m

field below Value Axis. This value cannot be lower than the maximum value of your

entire data set. If you don’t specify a number, the field displays the word “Auto,” and

the value is automatically calculated based on the data.

To set the value at the origin point of the value axis, type a number in the Minimum

m

field below Value Axis. This value cannot be greater than the minimum value of your

entire data set. If you don’t specify a number, the field displays the word “Auto,” and

the value is automatically calculated based on the data.

To specify the number of axis markings between zero and the minimum and maximum

m

values on the value axis, specify a number in the Steps field below Value Axis.

To display the data values on the value axis, select Show Value Labels or Show

m

Minimum Value from the Choose Axis Options pop-up menu below Value Axis.

To specify units for numbers on the value axis, choose an option from the Format pop-

m

up menu below Value Axis.

** **

**144 **

** **

**Chapter 9 **

Creating Charts from Data

** **

**Chapter 9 **

Creating Charts from Data

**145**

**Number: **Displays the data point value with no units. In the Decimals field, specify

how many decimal places you want to appear. To display negative values preceded

by a minus sign or in parentheses, choose –100 or (100) from the pop-up menu. Select

Separator if you want to separate the orders of magnitude on the left side of the

decimal.**Currency: **Displays the data point value as a monetary amount. Select the currency

unit symbol from the Symbol pop-up menu. In the Decimals field, specify how many

decimal places you want to appear. To display negative values preceded by a minus

sign or in parentheses, choose –100 or (100) from the pop-up menu. Select Separator if

you want to separate the orders of magnitude on the left side of the decimal.**Percentage: **Displays the data point value as divided by 100. In the Decimals field,

specify how many decimal places you want to appear. To display negative values

preceded by a minus sign or in parentheses, choose –100 or (100) from the pop-up

menu. Select Separator if you want to separate the orders of magnitude on the left

side of the decimal.**Date and Time: **Displays data point values with a date and time format.**Duration: **Displays data point values as a unit of time, for example, seconds, minutes,

or weeks.**Fraction: **Displays data point values less than 1 as one integer over another. (If your

values are greater than 1, you won’t see any fractional representation of your data.)

Choose how accurately you want the fractions rounded off in the Accuracy pop-up

menu. Choosing an option such as Halves or Quarters represents the values as a

portion of the total pie, rounded to the nearest division you selected. **Scientific: **Displays data point values in scientific notation, where 10 raised to a power

is represented as E+ an integer. In the Decimals field, specify how many decimal places

you want to appear.**Custom: **Choose a custom number format you’ve already created, or create a new

one. See “Using Your Own Formats for Displaying Values in Table Cells” on page 184 for

more information.

**To display category (data set) titles:**

** **

**1**

Choose Show Categories from the Choose Axis Options pop-up menu below Category

Axis, and then do any of the following:

** **

**2**

To show or hide some of the category titles, do either or both of the following:

Specify the interval at which you want category labels to appear by typing a value

Â

or using the stepper in the “Label every ... categories” field. For example, a value of

2 displays every other category title, a value or 3 displays every third category title,

and so on.

Choose Show Last Category from the Choose Axis Options pop-up menu below

Â

Category Axis, if you want the title of the last category to appear.

**To add or hide an axis title:**

** **

**1**

Choose Show Title from the Choose Axis Options pop-up menu below Category Axis

or Value Axis.

** **

**2**

Select title text that appears and type the title you want.

** **

**3**

To format the title’s text attributes, see “Creating Outlined Text” on page 52.

** **

**4**

To hide the title, deselect the option in the same pop-up menu.

**To set a linear, logarithmic, or percentage scale for the value axis:**Choose Linear Scale, Log Scale, or Percentage Scale from the Choose Axis Options pop-

m

up menu below Value Axis.

Percentage scales are available only for 2D stacked bar, column, and area charts;

linear and logarithmic scales are available only for 2D charts that aren’t stacked. 3D

charts can only use a linear scale. (For pie charts, you display values as percentages by

choosing Show Pie Values as Percentages from the Data Point Settings pop-up menu.)

To change the color and texture of series elements, or to format data point symbols

and value labels, use the Series pane of the Chart inspector. See “Formatting the

Elements in a Chart’s Data Series.”

For formatting options that are unique to a given chart type (for example, the spacing

between bars, for bar charts, or the spacing between wedges, for pie charts), see the

sections specific to those chart types.

You can also show error bars and trendlines on most chart types. See “Showing Error

Bars in Charts” on page 148 and “Showing Trendlines in Charts” on page 149.