gui_sa
05-22-2008, 01:32 PM
Hello there,
I?m having problemas with creating charts with no especific number of lines.
The program gets some data from the internet every time i run it, and i need to create a chart with it, but i can?t figure out how to put more data in the chart every time i run it...
If you understood what i wanted to say please help!
Thx
Sub charts()
Dim n As Integer
delete
n = Cells(65130, 1).End(xlUp).Row
With ActiveSheet.ChartObjects.Add _
(Left:=0, Width:=230, Top:=75, Height:=225)
.Chart.SetSourceData Source:=Sheets("Dados").Range(Cells(n, 1), Cells(n, 2)) 'How Can i fix the range?
.Chart.ChartType = xlXYScatterLines
End With
I?m having problemas with creating charts with no especific number of lines.
The program gets some data from the internet every time i run it, and i need to create a chart with it, but i can?t figure out how to put more data in the chart every time i run it...
If you understood what i wanted to say please help!
Thx
Sub charts()
Dim n As Integer
delete
n = Cells(65130, 1).End(xlUp).Row
With ActiveSheet.ChartObjects.Add _
(Left:=0, Width:=230, Top:=75, Height:=225)
.Chart.SetSourceData Source:=Sheets("Dados").Range(Cells(n, 1), Cells(n, 2)) 'How Can i fix the range?
.Chart.ChartType = xlXYScatterLines
End With