I have an excel spreadsheet which is updated regularly. It contains 3 columns, Class, X-data, Y-Data, there are approimately 100 rows of data which can be divided into say 5 classes or groups which I use as the series names. However these classes can change. Is there a way I can plot an x-y scatter graph for each graph where it automatically updates. I was thinking of something Like if class = 11B then plot X Y for series 11B.
0 · ·