R
Richard
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
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