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/ChartsH...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.