| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically create a chart
I am in the process of automating a chart creation and get stuck on this line:
'WS is declared as a worksheet ActiveChart.SeriesCollection(1).values = WS.Range("G34, I34, K34, M34, O34") I want to create a series in a chart by selecting multiple noncontinguous cells, but I run into errors executing this line. Can someone point out what is wrong? Thanks, YH |
| 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
