I want to create a graph in excel and get my spread sheet to yse the graph and give me the answer?

The data to be yzed has to come from somewhere, but it doesn't necessarily have to come from spreadsheet cells you populate manually. It is conceivable that you could have the raw data in an external file (perhaps in comma-separated-variable format, or .CSV), and you could use a macro to read it into a range of cells. From that point, you could have separate macros for developing a chart view of the data and for deriving your "answer" through programmatic ysis. The only thing you need to be certain of is that the "answer" can be arrived at algorithmically so you can write a macro to do it.