When you set up a line graph, Excel automatically adjusts the Y-axis to accomodate the selected data series.

However, I don't actually want Excel to do this - I want the Y axis to automatically adust to a minimum and maximum value from elsewhere on my spreadsheet.

I can manually set the limits for the Y axis, but this isn't really much use to me as I need it to auto-adjust based on these mimimum and maximum values which will change depending on input data.

I've managed to achieve this using an Excel add-in called Autochart, which works really well. However, I need to distribute this spreadsheet to a number of colleagues and business contacts, and I don't want them all to have to install this add-in in order to use my sheet.

Does anyone know of any way I could go about achieving this? If the solution involves VBA, some explanation about how to input the code would be really useful as I'm not very VBA experienced

Thanks in advance.