higlighting ranges of rows in excel
I have a large database of 20 or so assorted measurements covering a long period of time. Some measurements are available for the full range of dates while others are only available over some lesser range. I just have a list of dates in column one and the rest of the data placed according to the dates that they are available. I am looking to plot many graphs of measurements side by side looking for correlations and other relationships. Each time I make a graph I need to highlight that range of dates for which all the columns in the graph have data available. This seems like a rather agonizing process involving ridiculous amounts of scrolling hunting for the start and end points of the data- also quite often I forget which data belongs in which column since the column label is written on the first row only.
|