Microsoft Office Tutorials and References
In Depth Information
Creating a multiline category axis
Fortunately, Excel allows you to specify time values in the Scale tab of the
Format Axis dialog box. These time values are then converted to serial number
times. For this chart, I entered the following scale values:
Minimum axis scale value: 6:00 am
Maximum axis scale value: 2:00 pm
Major unit: 1:00:00
Excel converts these times to numerical values. Time values are expressed as a
percentage of a 24-hour day. For example, “6:00 am” was converted to 0.25
because 6:00 a.m. is 25 percent of a 24-hour day. The Major unit value (1:00:00)
was converted to 0.0416666666666667 — the value that represents 1 ⁄ 24 of a day.
Creating a multiline category axis
Most of the time, the labels in a category axis consist of data from a single column
or row. You can, however, create multiline category labels, as shown in Figure 4-27.
This chart uses the text in columns A:C for the category axis labels.
Figure 4-27: The category axis contains labels from three columns.
Search JabSto ::

Custom Search