Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Primary/Secondary Axis series count
Hi, I have a VBA function like so: Code: -------------------- Private Sub AddSeries(ByVal strName As String, ByVal rngValues As Range, ByVal rngValuesX As Range, ByVal xlAxis As XlAxisGroup) With Charts("Chart").SeriesCollection.NewSeries .AxisGroup = xlAxis .ChartType = xlLine .Name = strName .Values = rngValues .XValues = rngValuesX End With End Sub -------------------- Sometimes I add a series to the Primary Y axis and other times to the Secondary. How can I determine how many series are on the Primary and how many on the secondary????? Application could begin with an unknown number of series already present on each axis so can't use a counter. Cheers, Rayden -- raydenl ------------------------------------------------------------------------ raydenl's Profile: http://www.excelforum.com/member.php...o&userid=25668 View this thread: http://www.excelforum.com/showthread...hreadid=390832 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
series graph -- one series being added to another series | Charts and Charting in Excel | |||
Dynamic series in Chart | Charts and Charting in Excel | |||
How do I add a second axis to a graph with 2 data series? | Charts and Charting in Excel | |||
graphing two series on x axis | Charts and Charting in Excel |