I have a further problem from this post http://www.excelforum.com/excel-char...html?p=3000965 I have everythign set up and working. However while the maximum values on the y axis changes I need the minumum value to change with different graphs. Is this possible? I'm not very experienced with macros but I'm willling to try.