Linked Chart resizes in Word

[Helen]

I'm using Office 2007 - can't find the version of Word (still not fully au
fait with it yet).

I have an Excel spreadsheet that contains lots of data that generates
various charts. Each chart is on a separate sheet and the page size has been
resized so that it will fit into a table cell in Word. Each month I enter
new data, which feeds into the Excel charts, which in turn are updated in my
linked Word document.

Since moving to Office 2007 (from 2003) I'm finding that any new charts
created or charts are ameneded they are being resized in Word so that I can
only see the x-axis. Here's a few pics to try and explain.

Here's the Excel chart:
http://i86.photobucket.com/albums/k84/mau652/Misc/Excelscreen.jpg

Here's the chart, automatically resizing, in Word (pasted into a table, but
is just the same if posted directly on the page)
http://i86.photobucket.com/albums/k84/mau652/Misc/Excelscreen.jpg

I've looked at everything, even re-creating the charts again, but I'm still
getting this resizing. The only way round it is for me to find a PC with
Office 2003 on it and create the charts from there. Does anyone have any
idea why it's doing this. Is it a problem with our set up or is it a glitch
in Word?

Thanks
Helen

 

[DeanH]

See the previous posting which answers the autoupdate issue.
http://www.microsoft.com/communitie...hics&mid=5f338d72-4d4d-4daa-be75-97aca8da0c69

Once you have sized these they should not resize after update, but if they
do, try them in a single cell table (without borders), as the import will
size to the cell.

Hope this helps
DeanH

 

[Helen]

Thanks Dean

I am actually doing this, the charts automatically updates when I open Word,
but they are resizing, especially if I further update the data in Excel and
then right-click on the chart in Word and 'Update Link' - the chart data
updates, but it also resizes the chart. It shouldn't, but it does and that's
my query. The table is already a single cell without boarders.

Perhaps "re-size" is the wrong word, the size of the chart object stays the
same, but it just shows the lower bottom right of the chart, more of a
re-location of view.

 

[DeanH]

Already in a table Cell, doh! though that would be it...

What size is the original in Excel? Can you resize this to compensate for a
possible relocating to the 0,0 position? (that is the bottom left corner) As
your example seem to have a large area of "non-chart" maybe trim these down.
By the way, your second example seems to be a duplicate of the first, ie not
showing the problem in Word.
Hope this helps.
DeanH