Paste/Insert Excel chart over more then 1 page in Word

[JimS]

I'm populating a word document with several Excel Tables and Charts but cannot figure out how to paste a large (many rows) Excel Chart in Word. The chart needs to span 2 (sometimes more) pages.

I'm using VBA in Excel to do the copy / paste and have tried several methods but cannot find anyway to make a large chart cross-over to the next page.

Is this possible?

Thanks for any and all help...

Jim

[macropod]

Hi Jim,

Objects inserted into Word documents cannot span more than one page. You could, however, insert the data into a Word table - which can span multiple pages.

[JimS]

Do you know of any documented procedure on how to do this?
I have been trying to work with a table but cannot get it to span 2 pages.

Thanks...

Jim

[geekgirlau]

If your code creates a table (1 row x 1 column) and then pastes the chart within that table, it should automatically expand as necessary.

[macropod]

Hi Jim,

For cells containing data, simply copying & pasting them into Word should work. If not, try Edit|Paste Special in Word, and use the 'Formatted text (RTF)' option.

Charts, however, can only be pasted as Chart objects. So you have to either make them fit a single page or paste as a picture (via Edit|Paste Special) onto multiple pages then crop the picture on each page to suit your requirements.