Hi,
Just started using VBA and I need a bit of advice how to create a specific type of chart.

I have two arrays 'doserate' and 'bendingcurrent' - the maximum number of elements in these arrrays is 41 and I have another variable 'pos' which indicates the last non zero element in both the arrays.
I want to plot a chart with the x axis showing the 'bendingcurrent' values between the values of bendingcurrent(1) to bendingcurren('pos') and y axis showing 'doserate' between the values of doserate(1) to doserate('pos').

I want an x-y scatter chart with smoothed lines and I would like the x-axis scaling only between the values of bendingcurrent(1) and bendingcurren('pos')

Help!