Lets see if I can make this make sense. I need to graph several data points.
The data points that I need are from a worksheet where there are columns in
between each data point. So, I want to grab cell A1 for one data point and
cell C1 for the next data point and so on. Other than recreating my chart of
data is there any way to reference that cell A1 and create a formula that
will add a column so that I can just copy and paste the formulas each time I
get new data?

So something like A(add a column)$1=C1?
Thanks for your help! It's making me nuts!