I am wanting to automate building scatter plots. I have four columns of data. A is the well name, B is the date, and column C and D are production values. I want to plot only the days the well is only, so column E calculates the number of producing days. The problem is I am continually adding new production days and having to insert rows between Well A and B. It would make things a lot easier if each time I updated the graph I could repaste all the data with the new data included (this is how I receive the data).
Please see attachment for the data layout and graph.
Thanks in advance!
Bookmarks