Problem Inserting Charts in Office 2007

  • Thread starter Thread starter Fishmidi
  • Start date Start date
F

Fishmidi

Guest
Bob,

I'm receiving something similar. When INSERT CHART is clicked and PIE is

selected, I receive "YOu must first close open dialogue boxes or CANCEL

EDITING MODE IN EXCEL"...after clicking ok on this, I receive the error

message about Combine Charts and pick another one...

I think there possibly might still be EXCEL 2003 on system; however, when

I'm working on this particular project, NOTHING else is open. Thanks, Fishmidi



"Bob Buckland ?:-)" wrote:



> Hi Dratino,

>

> What appears to be happening in this case is that Excel (which runs the chart engine for Office 2007) doesn't have a built in error

> message for the problem and the one you're seeing is the one it uses.

>

> In some of the cases where this one has come up it seems to have to do with a corrupted profile folder or permissions.

>

> See if the steps here from Mark Has, posted in the Excel charting discussion group (link below) help.

>

> =========

> Mark has

> "Had this problem as well.

>

> Not sure if its the exact same one.

>

> I was able to insert charts with all other user accounts except my own.

>

> If you can do that, then its likely that its the same issue.

>

> This is what I did to fix it.

>

>

>

> 1. Log in a local Admin - Very IMPORTANT!

>

> 2. Navigate to 'Documents and Settings'

>

> 3. Locate the problematic user account folder i.e. the one that is giving the chart error above...

>

> 4. BACK IT UP (to another drive)

>

> 5. Confirm back up done... then delete everything in that user account - all files and folders.

>

> What this does effectively is wiping out all Local Settings for that user account (and any cache that Office has created, so

> beware!)

>

> 6. Log out as local Admin and log in as the user that had the chart problem. Windows will now initiate a new clean setup for the

> user (basically it takes parameters from 'default user')

>

> 7. At this point launch excel and do a simple list and try creating the chart.

> This worked for me... hope it does for you. >>

> ==================

> Chart. I

> am able to click on the button, the Insert Chart window appears, but upon

> selecting any chart and pressing "ok", the same message appears.

>

> "Some chart types cannot be combined with other chart types. Select a

> different chart type."

>

> And no, I have only Office 2007 installed.

>

> And yes, I get the same results after running Office Diagnostic. No errors

> were detected with Diagnostic. --

> Please let us know if this has helped,

>

> Bob Buckland ?:-)

> MS Office System Products MVP

>

> >>*Courtesy is not expensive and can pay big dividends LINKS

> A. Specific newsgroup/discussion group mentioned in this message:

> news://msnews.microsoft.com/microsoft.public.excel.charting

> or via browser:

> http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel.charting

>

> B. MS Office Community discussion/newsgroups via Web Browser

> http://microsoft.com/office/community/en-us/default.mspx

> or

> Microsoft hosted newsgroups via Outlook Express/newsreader

> news://msnews.microsoft.com

>

>

>

>
 
You are posting to a 4yr old post and asking a question which is next to impossible

to follow with all the old copies of post that you inserted .





--

Peter



Please Reply to Newsgroup for the benefit of others

Requests for assistance by email can not and will not be acknowledged.



"Fishmidi" wrote in message

news:96CEDCCC-BAD3-4DA1-B69D-2E5E7909647E@microsoft.com...

> Bob,

> I'm receiving something similar. When INSERT CHART is clicked and PIE is

> selected, I receive "YOu must first close open dialogue boxes or CANCEL

> EDITING MODE IN EXCEL"...after clicking ok on this, I receive the error

> message about Combine Charts and pick another one...

> I think there possibly might still be EXCEL 2003 on system; however, when

> I'm working on this particular project, NOTHING else is open. Thanks, Fishmidi

>

> "Bob Buckland ?:-)" wrote:

>

>> Hi Dratino,

>>

>> What appears to be happening in this case is that Excel (which runs the chart

>> engine for Office 2007) doesn't have a built in error

>> message for the problem and the one you're seeing is the one it uses.

>>

>> In some of the cases where this one has come up it seems to have to do with a

>> corrupted profile folder or permissions.

>>

>> See if the steps here from Mark Has, posted in the Excel charting discussion

>> group (link below) help.

>>

>> =========

>> Mark has

>> "Had this problem as well.

>>

>> Not sure if its the exact same one.

>>

>> I was able to insert charts with all other user accounts except my own.

>>

>> If you can do that, then its likely that its the same issue.

>>

>> This is what I did to fix it.

>>

>> > before!>

>>

>> 1. Log in a local Admin - Very IMPORTANT!

>>

>> 2. Navigate to 'Documents and Settings'

>>

>> 3. Locate the problematic user account folder i.e. the one that is giving the

>> chart error above...

>>

>> 4. BACK IT UP (to another drive)

>>

>> 5. Confirm back up done... then delete everything in that user account - all

>> files and folders.

>>

>> What this does effectively is wiping out all Local Settings for that user account

>> (and any cache that Office has created, so

>> beware!)

>>

>> 6. Log out as local Admin and log in as the user that had the chart problem.

>> Windows will now initiate a new clean setup for the

>> user (basically it takes parameters from 'default user')

>>

>> 7. At this point launch excel and do a simple list and try creating the chart.

>> This worked for me... hope it does for you. >>

>> ==================

>> news:C7590BE6-6834-48E5-9BA1-C9F927FDBB89@microsoft.com...

>> Tried starting new document, saving immediately and using Insert -> Chart. I

>> am able to click on the button, the Insert Chart window appears, but upon

>> selecting any chart and pressing "ok", the same message appears.

>>

>> "Some chart types cannot be combined with other chart types. Select a

>> different chart type."

>>

>> And no, I have only Office 2007 installed.

>>

>> And yes, I get the same results after running Office Diagnostic. No errors

>> were detected with Diagnostic. > --

>> Please let us know if this has helped,

>>

>> Bob Buckland ?:-)

>> MS Office System Products MVP

>>

>> >>*Courtesy is not expensive and can pay big dividends

>> LINKS

>> A. Specific newsgroup/discussion group mentioned in this message:

>> news://msnews.microsoft.com/microsoft.public.excel.charting

>> or via browser:

>>

>> http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel.charting

>>

>> B. MS Office Community discussion/newsgroups via Web Browser

>> http://microsoft.com/office/community/en-us/default.mspx

>> or

>> Microsoft hosted newsgroups via Outlook Express/newsreader

>> news://msnews.microsoft.com

>>

>>

>>

>>
 
Back
Top