Very simple question....

Is there a way to get the max number of the SeriesCollection? The
reason I am asking is that I use a date range to properly configure
my chart Based off the dates, I may have different amount if
seriescollections.

I'm not sure what you're asking for. I hope this brackets your question, or
at least gives you a hint.

The maximum number of series in a chart: 255

The number of points in a series:
ActiveChart.SeriesCollection(i).Points.Count

The maximum Y value in a series:
WorksheetFunction.Max(ActiveChart.SeriesCollection (i).Values)

The maximum X value in a series:
WorksheetFunction.Max(ActiveChart.SeriesCollection (i).XValues)

Loop these last two to get the overall max:

For i=1 to ActiveChart.SeriesCollection.Count
If MaxY < WorksheetFunction.Max(ActiveChart.SeriesCollection (i).Values)
Then
MaxY = WorksheetFunction.Max(ActiveChart.SeriesCollection (i).Values)
Then
End If
Next

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"EAB1977" wrote in message
...
Very simple question....

Is there a way to get the max number of the SeriesCollection? The
reason I am asking is that I use a date range to properly configure
my chart Based off the dates, I may have different amount if
seriescollections.

Jon, that helped a lot! Thanks!