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?
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
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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks