G
Guest
Hello
I have a number of sets of data that create simple line charts.
I would like the user to be able to select a custom set to add extra lines
to a chart.
I just dont know how I can capture the data source from the chart so that I
can add extra lines to it.
eg
Private Sub ButtonX_Click
Dim ChartSource As String
ChartSource = Chart1.?datasource?
ChartSource = ChartSource + "F4:F15"
End Sub
Does this make sense?
David
I have a number of sets of data that create simple line charts.
I would like the user to be able to select a custom set to add extra lines
to a chart.
I just dont know how I can capture the data source from the chart so that I
can add extra lines to it.
eg
Private Sub ButtonX_Click
Dim ChartSource As String
ChartSource = Chart1.?datasource?
ChartSource = ChartSource + "F4:F15"
End Sub
Does this make sense?
David