Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveChart.SeriesCollection(1).Points(3).Select ERROR
Hi.
I need to apply the same color to the bars in a graph (via VBA), wether the graph has 3 bars or 7 bars. The problem that i face is that when the point (bar) doens´t exists excel gives back an error: ActiveChart.SeriesCollection(1).Points(3).Select in case of poínt 3 dont exists. Is there a way to teste if the point exists, to only apply the programing in that case? Thanks a lot!!! Jorge |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Obtaining the value of an ActiveChart.SeriesCollection(1).Points(2) | Excel Programming | |||
Runtime Error '1004' Method 'ActiveChart' of Object '_Global' failed | Excel Programming | |||
Error message on Activechart.XYGroups | Excel Programming | |||
VBA- SeriesCollection(1).Value error | Excel Programming | |||
Argument List Of ActiveChart.Location And ActiveChart.ChartType | Excel Programming |