Hi I am tryng to write a program in excel which will automatically create a
new series and add it to a chart. I need to create a new series from C2 and
C3 when C1 changes
The data to be plotted is numeric from C2 (X) and C3(Y), and C1 is alpha
numeric for example, in this case 3 series would be created and added to the
chart
C1 C2 C3
1A 0.5 400
1A 2 1000
2B 35 5000
3D 20 2000
3D 25 2500
3D 20 3000

Check out the example in this tutorial:

VBA to Split Data Range into Multiple Chart Series | PTS Blog
http://peltiertech.com/WordPress/vba...-chart-series/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



wizabit wrote:
> Hi I am tryng to write a program in excel which will automatically create a
> new series and add it to a chart. I need to create a new series from C2 and
> C3 when C1 changes
> The data to be plotted is numeric from C2 (X) and C3(Y), and C1 is alpha
> numeric for example, in this case 3 series would be created and added to the
> chart
> C1 C2 C3
> 1A 0.5 400
> 1A 2 1000
> 2B 35 5000
> 3D 20 2000
> 3D 25 2500
> 3D 20 3000
>
>