I need to create a running chart that will plot the production rate and
associated dates of four employees. I have seen examples of macros to
automatically resize a data range as new data is entered over time. That
accomplishes a portion of my problem but i also need a macro that will sort
the data by employee last name and then plot on a chart based on that sorted
data.