Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Has anyone encountered this? TIA - Bob
Sub ColorBySeriesName() Dim rPatterns As Range Dim iSeries As Long Dim rSeries As Range Set rPatterns = ActiveSheet.Range("A1:H66") With ActiveSheet.ChartObjects("Chart 1").Chart For iSeries = 1 To .SeriesCollection.Count Set rSeries = rPatterns.Find(What:=.SeriesCollection(iSeries).Na me) If Not rSeries Is Nothing Then 'Gets near end of the SeriesCollection (56th of 66) & doesn't assign correct 'ColorIndex .SeriesCollection(iSeries).Interior.ColorIndex = rSeries.Interior.ColorIndex End If Next End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Chart SeriesCollection Formula | Excel Discussion (Misc queries) | |||
Pie Chart Percentage incorrect | Charts and Charting in Excel | |||
Chart: range info from seriescollection? | Charts and Charting in Excel | |||
How do re-order values assigned by Excel for chart data? | Charts and Charting in Excel | |||
colorIndex listing for Chart with autoformat settings | Charts and Charting in Excel |