Specifying a column of data for the x-axis

[Jacek]

I presume this is a very simple task yet I really can't seem to find the solution after browsing the web for a good 30 minutes (and I also presume this question has been posed more than once..).

Anyway, what I would like to do is specify a particular column of data from another worksheet to serve as my x-axis for a chart in my current worksheet.

I really don't know how to write this into VBA code. All I have is my chart specifying its SourceData from a range variable that I defined for the actual plotted data.

So I would like to have the values from another worksheet in the range A2:A1442 as my x-axis values...how can I write that in VBA? Oh and I know that's a lot of values, so I don't expect to have all of them showing, but I would like to show the first and last (A1 and A1442) values at each end of the axis.

Thank you in advance!

 

[Steve=True]

in 2007 you can click on your chart, then click on Design Ribbon and then choose Select data.

Then in the dialog box you can change the
Horizontal (category) Axis Labels on the right side of the dialog box then just choose your range.