I have columnar data of X's and Y's under column headings which are Zip Codes, lots of Zip Codes. I need to graph the data for each Zip Code. As there are literally hundreds of Zip Codes, creating an individual graph for each Zip Code is prohibitively time consuming.

Is there a way to create a chart to a given range of X & Y values in the column and then copy/paste the cart along the row so that the ranges change with the copy/paste operation?

Also, ideally, the graph for each Zip Code would reside in a cell or within a button which was a single cell length and width. Then I'd like to just click the button or graph to view it.

Can these things be done with Excel. I have Excel 2000 on one computer and Excel 2007 on another.

Thanks,

LongFisher