If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Distribute dynamically charts with linked data as stand-alone charts
I have 25 charts based on dynamic ranges and featuring links to other
workbooks. My question is actually twofold:- 1. The charts all update themselves fine. I have about four charts per spreadsheet and I need to distribute the charts themsleves, but without the underlying data. What is the best way to do this. And what is the best way to do this programmatically. 2. I had assumed that he best thing would be to create reports by Shift-Copying the charts as they look on the screen to tables in Word and then formatting the document as is, but I think the code here to format Word into different sections, with different headers and footers, creating tables in Word to hold the charts (four per page - landscape) would have been too complicated. What would people recommend here? All I really need to do is to email the charts four specific charts per page so that they can be printed out! Richard Its a good job Einstein never had to fill out one of these Government Grant applications or we never would have found out what e equalled. The West Wing |
Thread Tools | |
Display Modes | |
|
|