Scatter Plot with 1000 Data Series

pmurtha · Jul 11, 2012

Hi. I am using Excel 2010. I want to make a scatter plot that contains about 1000 lines where each line is 3 points long. I have arranged my data as follows:

x1 x2 x3 y1 y2 y3
592 591 581 294 294 294
584 582 581 297 297 294
584 583 581 297 297 294
586 586 586 297 295 292
…

In other words, I want to draw each line of data above as one line on my scatter plot. I can make the chart by adding each line of data using the Select Data Source window to add each line as a new series. Since I have about 1000 lines, I would have to repeat the Add option 1000 times. Is there a faster or more efficient way to add hundreds of series to a chart? Thanks!

kpark91 · Jul 11, 2012

I have no idea why you would want 1000 series in one graph but you can use VBA to automate adding the series.
Depending on how your graph is presented you must change the following code (whether the graph is presented as a separate chart sheet in the workbook, or stored in a worksheet)

Code:

For Each ch In ThisWorkbook.Charts
    ch.SeriesCollection.Add _
        Source:=ActiveWorkbook.Worksheets("Sheet1").Range("B1:B10")
    Next ch

http://msdn.microsoft.com/en-us/library/ff194065.aspx
http://msdn.microsoft.com/en-us/library/aa174298(v=office.11).aspx

pmurtha · Jul 11, 2012

kpark91 said:
I have no idea why you would want 1000 series in one graph but you can use VBA to automate adding the series.
Depending on how your graph is presented you must change the following code (whether the graph is presented as a separate chart sheet in the workbook, or stored in a worksheet)

Code:

For Each ch In ThisWorkbook.Charts ch.SeriesCollection.Add _ Source:=ActiveWorkbook.Worksheets("Sheet1").Range("B1:B10") Next ch

http://msdn.microsoft.com/en-us/library/ff194065.aspx
http://msdn.microsoft.com/en-us/library/aa174298(v=office.11).aspx

Thanks! That should get me there!

Scatter Plot with 1000 Data Series

pmurtha

New Member

Excel Facts

kpark91

Well-known Member

pmurtha

New Member

Similar threads

Forum statistics

Share this page

Scatter Plot with 1000 Data Series

pmurtha

New Member

Excel Facts

kpark91

Well-known Member

pmurtha

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock