Thread: Expand charting data

I would like to chart 3 the columns of information based on the choice in a the drop down box and have it expand each month. I have attached a sample of what I want to accomplish. Also I found a very useful chart from this forum earlier and thought it would be simple to modify to accomplish what I was needing and as you can see, this has not worked for me.

XRange=OFFSET('Partial Range Drop down'!$B$5,0,0,COUNTA('Partial Range Drop down'!$B:$B),1)
WhichYear=OFFSET('One column'!YValues,-1,0,1,1)
XValues=OFFSET('One column'!$B$5,0,-1,COUNTA('One column'!$B:$B)-1,1)
YValues=OFFSET('One column'!$B$5,0,'One column'!$J$1-1,COUNTA('One column'!$B:$B)-1,1)

I would greatly appreciate any help/solution you may offer.
Thanks
Michelle

Thank you very much for you knowledge and quick reply.