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 |
#3
|
|||
|
|||
Distribute dynamically charts with linked data as stand-alonecharts
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 he http://peltiertech.com/Excel/XL_PPT.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Tushar Mehta wrote: 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. |
Thread Tools | |
Display Modes | |
|
|