Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem formatting series in VBA
Hi, I've created a sub that creates a series on a chart. The problem is that I have some problems formatting the series. Like changing color or type of series. Here's my sub: Code: -------------------- Sub DrawSeriesFromWorkBook(chrt As Chart, szName As String, Optional lColor As Long) Dim sSeries As Series Set sSeries = chrt.SeriesCollection.NewSeries sSeries.ChartType = xlXYScatterLinesNoMarkers If (IsMissing(lColor)) Then sSeries.Border.Color = RGB(0, 0, 0) Else sSeries.Border.Color = lColor End If sSeries.Values = "='" & ThisWorkbook.Name & "'!" & szName End Sub -------------------- I think my sub is Ok in a programmaticaly way, but since it is VBA I would be happy, if someone can tell me what is wrong with this way to format the series. BTW: How do I count the number of point in ThisWorkBook.Names("ABC")?? Nick -- El_Pablo ------------------------------------------------------------------------ El_Pablo's Profile: http://www.excelforum.com/member.php...o&userid=33129 View this thread: http://www.excelforum.com/showthread...hreadid=532614 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting a 4 Series Stock Chart | Charts and Charting in Excel | |||
Fill down conditional formatting series | Excel Worksheet Functions | |||
formatting series | New Users to Excel | |||
formatting data series | Charts and Charting in Excel | |||
Series Problem | Charts and Charting in Excel |