Here is my situation. I have to create several charts based on data that may
or may not exist in certain forms. I can program for those variables if I
wasnt using a chart...however my boss wants a chart!!

My specific issue is this:

I can't for the life of me, figure out how to get the values in a chart to
accept anything other than the "Sheet1!R2C1,Sheet1!R2C2" etc etc.

how do I get

"Activechart.SeriesCollection(1).Values = "

to work with dynamic ranges?