| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Access to a series, when it is assigned to an empty range
Hello,
I'd like to get access to a chart series via vba. This works fine with ActiveChart.SeriesCollection(1).Values = "='" & ActiveWorkbook.Name & "'!" & Diagramm1.Range("Chart1_Series1").Value this is a reference to a named range. So, if I assign the series to a range with values I can change the series to another range afterwards. But if I once have assigned a series to an empty range I do not have access to the chart series any more. The error message is:"unable to set the values property of the series object" Only manually it's possible to reactivate this series, then I can continue to run vba Does anyone have a workaround? Excel XP SP 3 Windows XP SP 3 Regards Werner |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
| Filling a series into a non-empty column | Excel Worksheet Functions | |||
| How to change empty ranges from a plot series without generating e | Excel Worksheet Functions | |||
| How can I chart a data series without showing empty cells? | Charts and Charting in Excel | |||
| Series referencing a document that I have no access to | Charts and Charting in Excel | |||
Linear Mode
