PLEASE HELP! Problems with ActiveChart.PlotBy = xlRows

Hi im am a begginer programmer and this is my first time using Excel VBA. I am using macors to generate a graph based on an average grade that i have calculated in another macro. I have to check a series of columns to see if any include the average data and if so locate the value that needs to be added to the graph. I was able to produce the graph, however the values are presented in different series and i cannot have that because i need to produce a trendline. When i run the code the error is in the "ActiveChart.PlotBy = xlRows" and it says that " The specified dimension is not valid for the current chart type.". However if i perform the operation manually it works perfectly. PLEASE HELPP! This is my code:

Please Login or Register  to view this content.

1) please edit your post and use code tags - see how-to in forum rules.

2) as you do not show a multi-column and multi-row range as data source there is no chance to use plotBy property. Moreover, your series are just 1 point each, so you cannot use trendlines. To use trendlines make your series contain more than one data point.

May be - try to collect all points and then plot them as one serie. for instance such main loop (not tested, because you pattched no sample workbook:

Please Login or Register  to view this content.