Hi,
I am using Excel 2007. I have attached a sample spreadsheet to help explain what I'm trying to do.
example.xlsx
I have multiple sets of data (I have listed only a few sets on the sample spreadsheet) and I would like to chart these sets of data individually quickly using using a scatter plot with smooth lines and markers. All sets of data share the same X-values C1:I1. The series names are listed in column A. Y-values are listed in columns C - I. Each set of data has 8 series (actually it is 7 but I didn't know how to enter a title for each plot which are in A2, A10, A18, A26 etc. so I added another series with those cells) The Y-values associated with each series are in column C - I of the same row. I have created a plot with the first set of data in the example sheet, but I have hundreds of sets that I need to do the same thing for. Is there a way to quickly do this without having to manually select each set of data and plot it?
Thanks
Bookmarks