Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart appearing/disappearing

    Hello,
    I have a file that I created once, which contains some charts in Chartsheets. Everything was ok until yesterday, when I opened the file, only to find the weirdest behaviour I have ever seen in Excel: the charts were all greyed out (like when the background was brought to front), but when I clicked on the chart itself, then it appeared. It is very strange, and I can hardly explain what happens, so I rather attach a small sample of it. It's just a file with one chart where you can follow the behaviour.
    Could anybody give me an idea of what could have happened here? Did the file get corrupted maybe?
    I tried clicking on the chart and Bring to front, tried various other things, but nothing seemed to help.
    It is pretty urgent that I get this file up and running as I have to update it for some clients that are waiting for it.

    Thanks a lot for any help, hint...
    K.
    P.S. The Excel/Office version that I am working with is 97, under Windows 98.
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart appearing/disappearing

    Under Tools, Options, under OPtions, there's an option to Show All, Show Placeholders, or Hide all. If Show Placeholders is selected, that will explain what's happening exactly. Select Show All.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart appearing/disappearing

    Thanks a lot, it worked.
    I was almost to give up, I considered the file corrupted.
    Today I learned another thing.

    Thanks again.
    K.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart appearing/disappearing

    Excellent.

    You can start sticking back some of that pulled-out hair now.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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