Solved: more chart questions....defining specific ranges to axes

[divingdingo]

i'm doing a very simple graph from two columns of data, to get the code i recorded a macro to insert a chart and it worked fine. however whenever i run the code back, it doesn't get the axes right and the graph is all muddled

what activechart objects do i need to use to set the x axis to be one range and the y axis another?

i've tried:

activechart.Axes(xlValue).SetSourceData Source:=Range("extrapolated!$F$17:$F$21")

for the y axis and (xlcategory) for the y

but Excel doesn't like it.

can anyone steer me in the right direction please?

hugely appreciated
mark

[Bob Phillips]

[vba]

ActiveChart.SeriesCollection(1).XValues = "=extrapolated!R17C6:R21C6"
[/vba]

[divingdingo]

thanks xld

sometimes i'm so close....yet so far !!

thank you for your patience with me.