XL5: System Appears to Hang When Creating Chart

Last reviewed: September 12, 1996
Article ID: Q110186
The information in this article applies to:

- Microsoft Excel for Windows, version 5.0

SYMPTOMS

When you create a chart in Microsoft Excel version 5.0 for Windows, Microsoft Excel may appear to hang if the chart contains a large number (500 or more) of data points and you have the TipWizard turned on.

CAUSE

If you have the TipWizard turned on, when you first create a chart, Microsoft Excel checks every point in the chart to see if the data label for that point overlaps the data labels for other points in the chart. If two or more data labels overlap, the following tip is displayed

   If data labels overlap, click one data label and drag it to an empty
   area.

Because this tip has been shown, Microsoft Excel does not check for any more overlapping labels.

However, if the chart contains no data labels, Microsoft Excel checks for overlapping labels until there are no more points to check. This process may take a long time, as much as one hour or more, depending on the speed of your computer and the number of data points involved.

WORKAROUND

To prevent a long delay when you create chart that contains a large number of data points, either of the following:

  • Turn off the TipWizard before creating the chart by holding down SHIFT while clicking the TipWizard toolbar button. Once you have created the chart, you can turn the TipWizard back on by holding down SHIFT while clicking the TipWizard toolbar button.

    -or-

  • If you force the tip that displays when you have overlapping data labels to display before you create the chart, the delay will not occur. To force this tip to display, do the following:

    1. In a new worksheet, enter the following data:

          A1: Alpha   B1: Bravo
          A2: 1       B2: 1
    
       2. Select cells A1:B2.
    
       3. From the Insert menu, choose Chart, and then choose On This Sheet.
    
       4. Click and drag on the current worksheet to create an embedded chart.
    
       5. In the ChartWizard - Step 1 of 5 dialog box, choose Finish.
    
       6. Double-click the chart to activate it.
    
       7. Select the first series in the chart, and choose Selected Data Series
          from the Format menu.
    
       8. Select the Data Labels tab, and under Data Labels, select the Show
          Label option. Choose OK.
    
       9. Select the Plot area of the chart. Resize the Plot area so that the
          "Alpha" and "Bravo" labels overlap each other.
    
       The following tip is displayed by the TipWizard:
    
       If data labels overlap, click one data label and drag it to an empty
       area.
    
       While this tip is displayed, you can create your chart without
       experiencing a long delay.
    
           NOTE: Because this tip is reset when you exit Microsoft Excel, you
           must display this tip again after you exit Microsoft Excel. You may
           want to save the chart created above into a workbook so that you can
           easily display the tip. After following step 8 above, select and
           copy the chart, paste it into a new workbook, and save the workbook.
           You can then use this chart to display the tip whenever necessary by
           double-clicking the chart and repeating step 9 above.
    
    


KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.