Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro that I have recorded. I know there is some duplicate
information here, but I am not worried about that. I have included a part of the code below. Basically if the "SeriesCollection" is not available on the chart for which I run the macro, the macro fails and gives me a runtime error. So in the example below, if SeriesCollection(3) doesn't have data, I would like it to jump to SeriesCollection(4). Is there a way to do that? Can anyone please help? I would greatly appreciate it. Conor ActiveChart.SeriesCollection(3).Select With Selection.Border .ColorIndex = 10 .Weight = xlMedium .LineStyle = xlContinuous End With With Selection .MarkerBackgroundColorIndex = xlNone .MarkerForegroundColorIndex = xlNone .MarkerStyle = xlNone .Smooth = False .MarkerSize = 3 .Shadow = False End With ActiveChart.SeriesCollection(4).Select With Selection.Border .ColorIndex = 10 .Weight = xlMedium .LineStyle = xlDash End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data disappears when I edit the chart. | Charts and Charting in Excel | |||
Edit Pie Chart Data Label | Charts and Charting in Excel | |||
Edit Chart to Change Source Data | Charts and Charting in Excel | |||
Excel VBA macro - need to edit code to skip a year | Excel Programming | |||
Argument List Of ActiveChart.Location And ActiveChart.ChartType | Excel Programming |