Excel: Custom Gridlines in Chart Do Not Display Properly

• Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0

SUMMARY

When you use major and minor gridlines on the catagory axis in a Microsoft Excel chart and then format the gridline patterns, some of the lines may disappear from both the screen and the print preview. The gridlines missing on the screen are different than those missing in print preview.

MORE INFORMATION

Steps to Reproduce Problem in Microsoft Excel Version 5.0

1. Create a chart in Microsoft Excel.

2. Set the color of the plot area to white. This makes the problem easier to recognize.

3. From the Insert menu choose Gridlines.

4. Add both major and minor gridlines for the X-axis.

5. Select one of the major gridlines by clicking a major gridline with the mouse.

6. From the Format menu, choose Selected Gridlines.

7. In the Patterns tab, select Style and choose the last style. Choose the OK button.

   The gridlines will now disappear.

Steps to Reproduce Problem in Microsoft Excel Version 4.0

1. Create a chart in Microsoft Excel.

2. From the Chart menu, choose Gridlines.

3. Add both major and minor gridlines for the X-axis.

4. Select one of the major gridlines by clicking a major gridline with the mouse.

5. From the Format menu, choose Patterns.

6. Select Style and choose the last style.

   The gridlines will now disappear.

7. Select one of the minor gridlines.

8. Repeat 5-6.

Note for version 3.0 and 4.0: If you select the seventh (second to last) pattern in step number 5, no gridlines will disappear; however, only a single gridline gets formatted. Viewing the chart in print preview will show the formatted gridline in a different position.

REFERENCES

"User's Guide," version 5.0, Chapter 18, "Formatting Axes, Gridlines, and Tick Marks"

"User's Guide 1," version 4.0, pages 471-473

"User's Guide," version 3.0, pages 469-471