Hey everybody!

I posted not too long ago with a similar question... here is the link:
http://www.vbforums.com/showthread.php?t=526111

This time, instead of just changing a calculation in the worksheet, I would like to change the range of a Chart. For example, let's say that the Chart takes data from Columns C & D (x & y axis, respectively), and ONLY the data from rows 80 to 350 (Rows 8:79 and 351:2800+ contain data also). I would like to allow the user to change the range plotted by the graph by changing the values in the cell. My initial thought was that you can't do this because Excel won't allow you to specify a range like 350:80 instead of 80:350. Any thoughts would be appreciated!!!

~AJ