1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Re: Problem Inserting Charts in Office 2007

Discussion in 'Microsoft Office' started by Fishmidi, Feb 12, 2010.

  1. Fishmidi

    Fishmidi Flightless Bird

    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.
    >
    > <Disclaimer: be prepared to re-enter any application settings you have had 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. >>
    > ==================
    > <<"Dratino" <Dratino@discussions.microsoft.com> wrote in message 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
    >
    >
    >
    >
     
  2. Peter Foldes

    Peter Foldes Flightless Bird

    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" <Fishmidi@discussions.microsoft.com> 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.
    >>
    >> <Disclaimer: be prepared to re-enter any application settings you have had
    >> 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. >>
    >> ==================
    >> <<"Dratino" <Dratino@discussions.microsoft.com> wrote in message
    >> 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
    >>
    >>
    >>
    >>
     

Share This Page