y-axis min adjustment

[VandyClint]

I have a file with about 200 line graphs of different ranges of data. The source data cell locations do not change but the data within them will. As excel auto-graphs the data, it tends to set the y-axis min values to 0, which essentially zooms out on a lot of graphs with high max values and makes them difficult to see. Is there a vba script or other solution I can run that will auto adjust the y-axis min values of ALL graphs to a dynamic value (example: 90% of the lowest point in the source data)? I have seen a vba example of this before, but as I understand it, I will have to write the same sub 200 times, one for each graph referencing the different source data. I was wondering if there might be a quick-fix that I might be missing that would adjust all the graphs to make them easier to read. Many thanks in advance for your help.

[vikasbhandari]

I have a file with about 200 line graphs of different ranges of data. The source data cell locations do not change but the data within them will. As excel auto-graphs the data, it tends to set the y-axis min values to 0, which essentially zooms out on a lot of graphs with high max values and makes them difficult to see. Is there a vba script or other solution I can run that will auto adjust the y-axis min values of ALL graphs to a dynamic value (example: 90% of the lowest point in the source data)? I have seen a vba example of this before, but as I understand it, I will have to write the same sub 200 times, one for each graph referencing the different source data. I was wondering if there might be a quick-fix that I might be missing that would adjust all the graphs to make them easier to read. Many thanks in advance for your help.

Send me a list of chart names, along with their localtion...that is sheet names and their workbook names. I will create one function for you.

[vikasbhandari]

I have a file with about 200 line graphs of different ranges of data. The source data cell locations do not change but the data within them will. As excel auto-graphs the data, it tends to set the y-axis min values to 0, which essentially zooms out on a lot of graphs with high max values and makes them difficult to see. Is there a vba script or other solution I can run that will auto adjust the y-axis min values of ALL graphs to a dynamic value (example: 90% of the lowest point in the source data)? I have seen a vba example of this before, but as I understand it, I will have to write the same sub 200 times, one for each graph referencing the different source data. I was wondering if there might be a quick-fix that I might be missing that would adjust all the graphs to make them easier to read. Many thanks in advance for your help.

Send me a list of chart names, along with their localtion...that is sheet names and their workbook names. I will create one function for you.