I have raw surveying data from a total station that I'm dropping into an excel workbook. My goal is to create a workbook that will process the raw data and output a profile (xy scatter plot) under a new tab for future surveys that I might not be a part of.
I have set up the formula's in the worksheet. They fill row 4-500. However, the issue is that I don't know how many data points (i.e., rows of data) will be collected at every survey in the future and I don't to include the rows of formulas with no data in them in the xy scatterplot. Is there any command to get around this (i.e., only include data in xy scatterplot from column m & n if there is data in row a)? Should I make a macro? Do you have any insight on the best way to approach this?
I hope that this question is straightforward. Please let me know if I can clarify. Thanks so much for any help you can provide.
Bookmarks