I have VBA working great it takes certain text file and then formats it the way it should be then I have VBA creating charts ......and on one set of data the chart is based on a certain depth and I have my axis formatted to chart the results based on that set of data.

The problem is the code I have formats the chart to show the data from the initial set using a depth range form 7000-16000

I noticed my new data starts from depth 15000 - 25000 - so the question is can you get the code to format the chart based on data ranges it pulls the information from like 15000-25000 not the original 7000-16000.

I hope this can be done. I also charts that do the same for time and the ranges are in the data I just don't know how to get the chart to use that information.