Microsoft KB Archive/104820

Mac Works 3.0: Horizontal Grid Lines in Spreadsheet Chart

PSS ID Number: Q104820 Article last modified on 10-22-1998

3.0

MACINTOSH

=
========================================================= 3.00 MACINTOSH kbother

= SUMMARY =

In a Microsoft Works spreadsheet, charts that you create will not have horizontal grid lines. The only grid markers that appear are at the intersections of the horizontal and vertical grid.

The only exception to this is if you choose a semi-logarithmic scale for the vertical axis. To do this, follow these steps:


 * 1) From the Chart menu, choose the chart you want to work on.
 * 2) From the Chart menu, choose Define Chart.
 * 3) In the Chart Type box, select Semi-Log.
 * 4) Click OK.

The semi-logarithmic scale exaggerates the size of smaller numbers and minimizes the size of larger numbers. This makes it easier to show large and small numbers on the same chart; however, it might not be appropriate for charts where the maximum and minimum numbers are closer together.

The other workaround is to place the chart into the draw layer and draw the lines by hand. To do this, follow these steps:


 * 1) From the Chart menu, choose the chart you want to work on.
 * 2) From the Edit menu, choose Select All.
 * 3) From the Edit menu, choose Copy.
 * 4) From the File menu, choose New, then click the Draw icon and choose New. This will open a new Draw document.
 * 5) From the Edit menu, choose Paste.
 * 6) Using the Line tool, draw the horizontal grid lines.
 * 7) When the lines are drawn, choose Select All from the Edit menu.
 * 8) From the Edit menu, choose Copy.
 * 9) From the Window menu, choose the Spreadsheet you are working on.
 * 10) From the Edit menu, choose Paste.

NOTE: The newly pasted chart will not be linked to the spreadsheet information. Therefore, any changes made to the spreadsheet will not be reflected on this chart.

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 3.00 mac mwksss semi log grid mwksdr

=
========================================================= Version : 3.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.