Hi,
I added some series to a chart and .seriescollection.count results = 6. That's OK.
Now, series(6) references to empty cells. I want to delete the series but that's not possible. Err. 1004. Series with data can be deleted without problems.
How can I access the series 6.
Chris
SeriesCollection(i).Delete
Hot Topic
- Export Access data with TransferSpreadsheet to Excel
- Autofill
- Excel VBA using ADO
- List box issues
- How do I call for all installed printers....
- Adding records and incrementing the date
- Select query returns non-existing data
- Sum of hours using select statement & VBA
- Lack of mouse scroll wheel support in VBA
- How to use ADO retrieve MSAccess attribute ?
Microsoft ISV
- Problems upgrading from Office 97 to Office 2003
- Microsoft Office Document Imaging no longer in Printers Folder, Using XP and Office XP Professional
- Calling procedures from a procedure
- Validation list macro
- Can you use VBA to access a spread sheet embedded in a word doc?
- Can't Edit the View >> A working ArithAbort method
- User form issue
- CRM 3.0 : Changed Contact view under customization but CRM do not reflect
- Elegance (and performance) Problem
- Compatibility Issue Excel 2000 and Excel 2003
SeriesCollection(i).Delete
Biju S Melayil
Thanks
Chris
pnp
Empty cells certainly cause problems when dealing with charts via the object model.
A way around the problem is to change the chart type. Column charts are quite happy of empty data series to be deleted.
With ActiveSheet.ChartObjects(1).Chart
With .SeriesCollection(6)
.ChartType = xlColumnClustered
.Delete
End With
End With
cmwith