How to get column and row information from charted data

[shellig]

In a chart, series are specified like:
=SERIES[ (series_name) , (X-values) , (Y-values) , (plot_order) ].
Range references in a SERIES formula are always absolute and always contain a worksheet name. If you have defined named ranges then the series formula can contain a named range in place of a range.

=SERIES('g2'!$G$36,'g2'!$A$37:$A$71,'g2'!$G$37:$G$71,7)
If I want to write VBA code that knows that my data starts on row 37 or that the Y values are in column G (numerically=7), how do I pull that information?
Is there a way?


http://www.j-walk.com/ss/excel/tips/tip83.htm
is probably a good starting point but honestly I am having a terrible time deciphering it as I am a sporadic VBA user.

Any hints?

[Leith Ross]

Hello Shellig,

It is difficult to answer a question that hasn't been asked. What is it you want to achieve?

Sincerely,
Leith Ross

[shellig]

http://www.excelforum.com/showthread.php?t=368250
This is the real question I am trying to solve.
I was trying to break down the steps in this question.
The graphed data is variable ranges depending on whether we are interested in 6 months, 1 week, etc.
I need to know what column and row I started graphing data in to apply a macro to color the data points based on the values in another column.
Thanks!
Shelli