Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Editing a chart causing Excel to close. (2002)

    Have enclosed a spreadsheet to see if problem occurs elsewhere.

    Highlight the word Mode on the chart and then delete it. Click in any cell outside the chart. What happens here on 4 different machines is that Excel closes down.
    Just wondering if it happens elsewhere. If not, what could possibly be happening on our machines.

    Have saved the file to a network drive and the local drive. Problem occurs no matter the file is opened from. Have also run Detect and Repair in Excel to see if the problem would correct itself. Problem continues.

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Editing a chart causing Excel to close. (2002)

    No problem on my PC. I'm using Excel 2002 SP-3.

    What happens if you do the following:
    - Click in any of the columns, this should select Series 1.
    - Select Format | Selected series...
    - Activate the Data labels tab.
    - Tick one of the check boxes (e.g. series name).
    - Click OK.
    - Select Format | Selected series... again.
    - Clear the check box you just ticked.
    - Click OK.
    - The labels should disappear, including the original one.
    - Save the workbook (under another name if you wish).
    - Click outside the chart.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing a chart causing Excel to close. (2002)

    I am using the same version of Excel as you.

    Followed your suggestion. When i clicked outside the chart after all labels had gone, I did not get kicked out of Excel.

  4. #4
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Monroeville, Pennsylvania, USA
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing a chart causing Excel to close. (2002)

    I also had no problem. I'm using 2003 SP2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •