Chart in Cell & Copy/Pasting Charts w/auto range change

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

Hi, have a look at the example file:

In A + B I have zip code and offset (you'll need to sort zipcode alphabetically/numerically)

In D + E I have the cells that plot in the graph.

In G2 I put the zip code I want to plot

In H2 I have the amount I need to offset the data by

In I to N I have the data that needs offsetting (you'll have to add extra data as zip code increases).

Anyway, that should give you and idea of how to do it?

Mark