Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good Morning,
I've got 50 charts on one sheet; each with a varying number of lines on each chart. Need to adjust all the series in one move. Thought I'd be able to have a loop within a loop: '=========================== Sub FindChartSeries() Dim myChartObject As ChartObject Dim mySeries As Series For Each myChartObject In ActiveSheet.ChartObjects myChartObject.Select For Each mySeries In myChartObject.SeriesCollection MsgBox "found series" Next Next myChartObject End Sub '=========================== Why is the above bugging out? Any help much appreciated Jason. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic chart - series label problem | Charts and Charting in Excel | |||
finding chart series low | Excel Programming | |||
Problem adding Series XValues to Chart using VBA | Charts and Charting in Excel | |||
Q. Pie Chart problem. Want to add series, from another worksheet. | Excel Programming | |||
international problem, decimal separator and chart series | Excel Programming |