Charting in excel

[wizabit]

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

 

[Jon Peltier]

Check out the example in this tutorial:

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

- Jon