ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel Charts in Word - adding rows (https://www.excelbanter.com/charts-charting-excel/206818-excel-charts-word-adding-rows.html)

Jennifer

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!!!!!

ShaneDevenshire

Excel Charts in Word - adding rows
 
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!!!!!



All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com