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
|
|||
|
|||
Selecting Charts in a Macro
I have a worksheet which contains 7 charts:
1st Chart = Chart 12 2nd Chart = Chart 7 3rd Chart = Chart 11 4th Chart = Chart 13 5th Chart = Chart 24 6th Chart = Chart 16 7th Chart = Chart 26 I have a macro which copies the worksheet it over to a new worksheet within the same workbook, the charts are then labelled: 1st Chart = Chart 9 2nd Chart = Chart 7 3rd Chart = Chart 13 4th Chart = Chart 10 5th Chart = Chart 2 6th Chart = Chart 12 7th Chart = Chart 15 The macro then tries to select each chart and change the source data, what I don't know is how excel will treat the chart numbers for other users on different PC's, will the chart numbers stay the same? Is there any way I can name the charts and keep that named reference in the Macro? Or is there a better way of doing this entirely? Thanks --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Herman -
I think you'll find what you need on this web page: http://peltiertech.com/Excel/ChartsH...ameAChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Herman Merman wrote: I have a worksheet which contains 7 charts: 1st Chart = Chart 12 2nd Chart = Chart 7 3rd Chart = Chart 11 4th Chart = Chart 13 5th Chart = Chart 24 6th Chart = Chart 16 7th Chart = Chart 26 I have a macro which copies the worksheet it over to a new worksheet within the same workbook, the charts are then labelled: 1st Chart = Chart 9 2nd Chart = Chart 7 3rd Chart = Chart 13 4th Chart = Chart 10 5th Chart = Chart 2 6th Chart = Chart 12 7th Chart = Chart 15 The macro then tries to select each chart and change the source data, what I don't know is how excel will treat the chart numbers for other users on different PC's, will the chart numbers stay the same? Is there any way I can name the charts and keep that named reference in the Macro? Or is there a better way of doing this entirely? Thanks --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
macro to create charts in worksheets with arbitrary names | z.entropic | Charts and Charting | 25 | June 19th, 2004 02:48 PM |
run macro on multiple charts | Hammer_757 | Charts and Charting | 1 | March 22nd, 2004 12:15 AM |
PivotChart formatting: macro for multiple unique charts | Jocelyn | Charts and Charting | 2 | January 20th, 2004 05:12 PM |
Selecting data for charts by criteria | Jon Peltier | Charts and Charting | 1 | October 29th, 2003 09:48 PM |
Using a Macro to automate Charts | Llednar | Charts and Charting | 1 | September 21st, 2003 01:45 PM |