Automatically change the values of the axes in a dynamic chart

[arb1985]

Hello!
After looking a video in Youtube, I have been able to use the OFFSET function in excel 2010 to make a dynamic chart.
I plot a X Y (Scatter) chart, and I use a cell to tell it from which row on should be plotted. It works perfect, but the axes values don't get properly updated. There is a way to set them dynamically? because leaving the Auto option doesn't seem to work properly...
Thank you for the help!

 

[Derek Brown]

Hello and welcome to The Board.
Have a look at the "Dynamic Charts" section in the index at the following link - I think that you will find the answer there:
Jon's Excel Charts and Tutorials - Index