| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing properties of a series with no data
I guess one way would be to trap the error.
Regards, Tom Ogilvy "Scott Hodson" wrote in message news:xTvWa.33299$Ne.7969@fed1read03... I'm iterating through my SeriesCollection in my chart and when I try to access any property of a series object that doesn't have any data in it I get "unable to get the <property property of the series class". How can I check to see if a series has any data in it so I can avoid this error? And why would I not be able to access, say, the Name property of a series just because it doesn't have any data yet it still is in the chart's SeriesCollection? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accessing data in linked Access table | Links and Linking in Excel | |||
| accessing data from Access | Excel Discussion (Misc queries) | |||
| Access data on spreadsheet without accessing the file?... | Excel Worksheet Functions | |||
| Pivot table accessing external data | Excel Discussion (Misc queries) | |||
| Accessing List Data | Excel Discussion (Misc queries) | |||
Linear Mode
