Distribute dynamically charts with linked data as stand-alone charts

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
 
T

Tushar Mehta

Have you considered keeping it in XL? Create a new workbook. In the
original workbook, select a chart, then use SHIFT + Edit | Copy
Picture... switch to the new workbook and use Edit | Paste.

Repeat for all charts. Use the macro recorder to record your actions
for one chart and generalize the XL generated starter code to work with
all charts in all worksheets in the original workbook. If you don't
know how, share the code for one chart and someone should be able to
help you out.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
J

Jon Peltier

Or PowerPoint. I keep my workbooks to myself, and distribute pages with
four charts and a title as PowerPoint slides. I have a macro that takes
the charts I've selected, and individually copies them to PowerPoint.
This has saved wear and tear on my Alt and Tab keys. Some of the code is
presented here:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top