Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2007
    Posts
    171
    Thanks
    3
    Thanked 0 Times in 0 Posts

    SOLVED! Copy+pasted Pivot Chart from Word doc to another Word doc. Smashed

    Hi all,

    I copy+pasted an Excel pivot chart from a Word doc to another Word doc.

    The chart got a little smashed up. The straight lines of a graph plot turned curvy and lots of other problems - but the basic shapes was still visible.

    As a work-around I had to copy them as bitmap images, but I want to preserve them as pivot charts.

    Any ideas what's causing this and how to fix it?

    TIA

    -avraham
    Last edited by amakeler; 2012-10-24 at 03:52.

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    2 Star Lounger
    Join Date
    Dec 2007
    Posts
    171
    Thanks
    3
    Thanked 0 Times in 0 Posts

    SOLVED! Copy+pasted Pivot Chart from Word doc to another Word doc. Smashed

    Ok - I fixed it myself.

    Here's what is happening, AFAIU, and the work-around.

    The Solution to the Excel Pivot Charts ‘breaking’

    There was no direct solution. This seems to be a bug – or maybe just a lack of backward compatibility – since the original doc was a ‘Word 2003 compatible’ file.

    I solved this as follows:

    1. Save As Word 2007/2010 file.
    All Pivot Charts immediately get broken.

    2. Right-click any of the charts to open the Excel source file.

    3. Copy each of the charts from the Excel source file back into the Word doc.
    They should all be OK now.

    This is not the sort of surprise you want to bump into at 11:00 at night when you want to release something…

    -avraham
    Last edited by amakeler; 2012-10-24 at 03:51.

Posting Permissions

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