Macro to adjust graphs based on input

Something like this,

Please Login or Register  to view this content.

Thank you for your help, the code works great but it doesn't select the whole range for graphing, it takes a range from say B9:B19 instead of B9:B20.

Is there anything I can do to fix this?

Also what if I want this repeated for different sets of data in the same worksheet (to make several graphs)? Can that be possible?

Thank you greatly for your help.

Please Login or Register  to view this content.

Here is what the part of the code looks like now...and it keeps going with more graphs: How do i make the code you gave me apply to this worksheet? Sorry for all the questions but I am fairly new at this.

Thank you

Please Login or Register  to view this content.

What happens is that the user selects the months to graph and the formula (Cells H and I) figures out what cell number that would be. Then it graphs in row B reference cell H to row B reference cell I and the same for the other coordinates...D(H) to D(I)

why not post the workbook with the code, it would make things a lot clearer

Hi Andy,

Here it is. Thank you

Originally Posted by Andy Pope

why not post the workbook with the code, it would make things a lot clearer

Yes. The first thing it wants to do is open a text file on YOUR pc.

You need to include at least a couple of charts worth of test data.

Originally Posted by Andy Pope

Yes. The first thing it wants to do is open a text file on YOUR pc.

You need to include at least a couple of charts worth of test data.

Here is some data.

Thank you Andy