Microsoft Office Tutorials and References
In Depth Information
Using a Workaround to Display a Time-Scale Axis
16. Type 1800s . Click the edge of the text box to change it from a dashed line to a solid
17. While the text box is selected, select Center Align from the Home tab. Select Vertical
Center Align. Select Increase Font Size from the Home tab.
18. While the text box is still selected, select Format, Shape Outline, Black on the Layout
tab in order to outline the text box.
19. Click the text box and start to drag to the right. After you start to drag, hold down the
Shift key to constrain the movement to the right. Hold down the Ctrl key to make an
identical copy of the text box. When the left edge of the new text box is aligned with
the vertical line at 1900, release the mouse button.
You must start dragging before you hold down the Ctrl+Shift keys. Microsoft interprets Ctrl-click as the
shortcut to select an object’s container.
20. Click in the text box and change the text from 1800s to 1900s .
21. On the Layout tab, select Chart Title, Centered Overlay Title. When the title Chart
Title appears, it is selected.
22. Click inside the Chart Title text area to enter Text Entry mode. Overwrite the default
text in the title by typing Growth of USA , press Enter, type by # of States , press
Enter, and type 1787-1999 .
23. Click the border of the chart title to exit Text Entry mode.
24. Drag the chart title to a new location in the lower-right corner of the chart.
The result is a chart that appears to show a line chart that spans 217 years. The line is
scaled appropriately using a date-based axis.
Using a Workaround to Display a Time-Scale Axis
The developers who create Microsoft Excel are careful in the Format Axis dialog box to call
the option a date axis. However, the technical writers who write Excel Help refer to a
timescale axis. The developers get a point here for accuracy because Excel absolutely cannot
natively handle an axis that is based on time.
A worksheet in the download files is used to analyze queuing times. In Column A, it logs
the time that customers entered a busy bank. Times range from when the bank opened at
10 a.m. until the bank closed at 4 p.m.
After you enter planned staffing levels in Column C, the model calculates when the
customer will move from the queue to an open teller window and when he or she will leave the
window based on an average of three minutes per transaction.
Search JabSto ::

Custom Search