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
Bookmarks