First time poster here. I've been working in Excel for awhile, but not with such large datasets. I'm starting to learn VBA also, but was looking to do this without it, if possible. After searching google, I don't think it's possible, but maybe you all can help me.
Is there an easy way to create a chart with multiple series, but not actually put each of the series in manually?
The problem is that I have 2 columns that I want to plot, but each series could be 1 point or many points. Each series is represented here by a letter (j,k,m,n) and then I'd like to plot (3,9) as if it were an (x,y) pair.
The reason I would like to not select all these by hand is that there are about 100 different series (which I would not put all on the same graph) and I'm going to have to do this on multiple spreadsheets for different data sets.
Thanks in advance!
-njs27
Book.xlsx
Bookmarks