A hundred of series in a xlScatter Graph.

[y]

How can I easily add my series (each one with its own X and Y values) to my graph?
Do I need VBA for this task?

Thanks in advance, Alex.

 

[Wei-Dong XU [MSFT]]

Hi Alex,

If you want to add the series automatically, you will need to use macro. If not, you can add the series manually. I introduce each for you below:

1) Manually
a) right click one chart and select "Source data..."
b) select "Series" tab in the pop up window "Source Data"
c) you will find the series list box in the left side of the tab
d) click add button to insert one series and specify the value in the right input text box

2) Macro
You can find the sample code from the MVP Jon's Excel page.
Quick Chart VBA Examples
http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html#addseries

Please feel free to let me know if you have any further questions.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Yan-Hong Huang[MSFT]]

Hello Alex,

I am reviewing this thread. Is the problem resolved already? If there is
any question on it, please feel free to post here and we will follow up.

Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.