T
terryc
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.
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.