Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SeriesCollection Object Issue
If the SeriesCollection Object on the chart has all values contained within
it as "#N/A", then the object effectively becomes invisible from the code and when attempting to set the values to it again via code, it errors out as the code can't see the object on the Chart Object (Note, Chart Object isn't the same object as the ChartObject Object). However, on the spreadsheet side, one can clearly go into the DataSource of the chart and see it there. What needs to be done to get this issue resolved as I must still be able to print out the charts, even if at least one of the series contains all "#N/A" values, which is needed for interpolated charts to work properly. For the time being, I'm having to do this manually, and I don't like that idea. -- Thanks, Ronald R. Dodge, Jr. Production Statistician Master MOUS 2000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method 'SeriesCollection' of object '_Chart'failed | Excel Programming | |||
Add method of SeriesCollection object clears Windows clipboard | Excel Programming | |||
Object variable issue | Excel Programming | |||
Formatting a new seriescollection in a chart object | Excel Programming | |||
Adding to the SeriesCollection of a chart object in VB6 | Excel Programming |