Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series reference on a chart
I'm trying to reference a series on a chart with seriescollection(). Ho can I find out what the index number of the series is? I've tried usin the name of the series, but I can't seem to get it to work -- kev_0 ----------------------------------------------------------------------- kev_06's Profile: http://www.excelforum.com/member.php...fo&userid=3504 View this thread: http://www.excelforum.com/showthread.php?threadid=56389 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series reference on a chart
Example:
Sub GetChartSeries() Dim s As Series Dim cht As Chart Set cht = ActiveSheet.ChartObjects(1).Chart Set s = cht.SeriesCollection("Sales Data") s.Border.ColorIndex = 5 s.Fill.ForeColor.SchemeColor = 5 End Sub Regards, Greg "kev_06" wrote: I'm trying to reference a series on a chart with seriescollection(). How can I find out what the index number of the series is? I've tried using the name of the series, but I can't seem to get it to work. -- kev_06 ------------------------------------------------------------------------ kev_06's Profile: http://www.excelforum.com/member.php...o&userid=35046 View this thread: http://www.excelforum.com/showthread...hreadid=563898 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
how to plot column chart with one series against multiple series. | Charts and Charting in Excel | |||
how do I define a chart series with an indirect reference | Charts and Charting in Excel | |||
Add Series to a chart failure and Disappearing Series | Excel Programming | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel |