| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically create a chart
The code I posted deals with the sheet naming once you specify the range
to use. You can use the chartobjects collection to loop through the charts on a sheet, but only you know which range to use with what chart. Cheers Andy YH wrote: Since I will be creating 3 to 4 charts each on different worksheets, is there a way I can substitue the activechart name and sheet name with variables? That way I can use the same set of scripts to generate charts for different worksheets? Can someone show me how to change this line below to use variable names for the activechart and sheet? ActiveChart.SeriesCollection(1).values = "=(sheet1!R11C7,Sheet1!R13C7,Sheet1!R18C7,Sheet1!R 20C7)" Thanks, YH -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create line chart with two axises in Pivot Chart | Charts and Charting in Excel | |||
| How to automatically create a thumbnail of a published chart/image | Charts and Charting in Excel | |||
| Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
| able to automatically create a chart in Excel | Charts and Charting in Excel | |||
| Macro to Create a Chart and Update it Automatically | Charts and Charting in Excel | |||
Threaded Mode
