Excel Charts in Word - adding rows

I have an excel chart (of a balance sheet). On 2 different pages in Word
using the same worksheet, I pasted the first section (assets), which contains
10 rows, and second section (liabilities), which contains 5 rows as pasted
link as a MS Office Word Doc Object so that it updates each time I change the
numbers in excel.

My problem: When I try to add an additional row(s) in the liabilities
section and update the link in Word, the previous last row does not appear on
the Word document.

How do I make sure that the pasted link updates the addtional rows without
moving the previous bottom rows out of sight on the word document link?????

I know there is a way, but I cannot remember how to do it. THANKS!!!!!

Hi,

The rows may be there but you may need to resize the chart in Word to see
them. Try a basic resize. If that doesn't work double click the chart to go
into edit mode and note whether the data is showing.

--
Thanks,
Shane Devenshire


"jennifer" wrote:

I have an excel chart (of a balance sheet). On 2 different pages in Word
using the same worksheet, I pasted the first section (assets), which contains
10 rows, and second section (liabilities), which contains 5 rows as pasted
link as a MS Office Word Doc Object so that it updates each time I change the
numbers in excel.

My problem: When I try to add an additional row(s) in the liabilities
section and update the link in Word, the previous last row does not appear on
the Word document.

How do I make sure that the pasted link updates the addtional rows without
moving the previous bottom rows out of sight on the word document link?????

I know there is a way, but I cannot remember how to do it. THANKS!!!!!