| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying a chart
Hi
have a look at http://peltiertech.com/Excel/Charts/...html#DelinkCht -- Regards Frank Kabel Frankfurt, Germany Marcotte A wrote: I have a large (12+ MB) inventory/sales tracking spreadsheet. I need to distribute the summary pages of this spreadsheet on a regular bases (2-3x a week probably). I have a macro that will copy paste special (values and formats) the summary pages, but there are also charts I would like to copy. Whenever I copy them, they always refer back to the original spreadsheet. Is there a way to copy a chart and have it refer to the same ranges on the sheet it is copied onto (these charts are embedded in worksheets, not on their own sheet). Or do I have to write a macro that will create the charts from scratch? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying a worksheet tab with a chart, without losing chart formatt | Charts and Charting in Excel | |||
| Chart format copying? | Excel Discussion (Misc queries) | |||
| Copying data from one chart to another - how? | Charts and Charting in Excel | |||
| copying excel chart formats from one chart to another | Excel Discussion (Misc queries) | |||
| copying a chart | Excel Programming | |||
Threaded Mode
