Morning Everyone,

I am having a bit of trouble with something I would have imagined is fairly straightforward.

I have creted a GUI using a user form in VB.

I want this user form to display a graph based of the contents of the worksheet.

I have found the chartspace icon on the toolbox and have added a chartspace to my form.

Currently I have one button controlling the updating of this graph uising the code:

Private Sub CommandButton1_Click()


End Sub


I am trinyg to use the Chartspace1.datasource property to assign a data source to the graph for plotting but I cannot find syntax anywhere that will work.

Could someone give me an example of code that will plot the follwing data on a Form.

range A1:Z1 on Sheet one when the button is clicked.

Thanks in advance for your help.


Mike