+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Registered User
    Join Date
    10-14-2007
    Location
    Oak Harbor, WA
    Posts
    2

    Grayed-out chart

    I'm using Excel as part of MS Office 2003. I encountered a strange problem after adding a worksheet to an existing workbook. On the new worksheet, I entered some data and used the chart wizard to create a chart. The chart was fine but it grayed out when I clicked on a worksheet cell -- the chart displays ONLY when I click inside the chart borders, otherwise it's a gray rectangle.

    Using the same process, I created charts on the other worksheets within the workbook and got the same result. I repeated the process on other workbooks and I did NOT have the same problem.

    Based on the above, I assume that I changed a setting on the problematic workbook to create the "gray chart" effect.

    Any ideas?

  2. #2
    "Eagle Eyed" Forum Moderator oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Work) and 2007 (Home)
    Posts
    7,130
    Hi radrian,

    Welcome to the forum, try this, click on the spreadsheet, not the chart, go to Tools > Options > View > Object and Select All
    oldchippy
    -------------


    If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    10-14-2007
    Location
    Oak Harbor, WA
    Posts
    2

    Thank you -- problem solved

    Thank you for the welcome and thanks for the assistance -- it worked and all is well. I'm a bit confused as to why the "Show placeholders" radio button was checked instead of the "Show all" button but I suppose it's moot now. The important point is the learning experience.

    Thanks again,

    radrian

  4. #4
    "Eagle Eyed" Forum Moderator oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Work) and 2007 (Home)
    Posts
    7,130
    Don't know the answer to the question, but glad to hear it worked for you.
    oldchippy
    -------------


    If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  5. #5
    Registered User
    Join Date
    10-16-2007
    Posts
    1
    I have this problem too.
    I'm using Excel 2004 for mac (version 11.3.6)

    Under my tools menu, there isn't an option line. I've looked around for something similar but haven't had any luck. Does anyone know how to fix this for macs?

    Thanks!


    UPDATE

    Nevermind, I found it. Its in the Excel Menu>Preferences>view click under objects, "show all".
    Last edited by lrc3233; 10-16-2007 at 03:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0