In my contiuing research I have found that using web components in a form is OK, that is according to Alvin Bruney in his post:
[uml]http://www.developersdex.com/asp/message.asp?p=2912&ID=%3C49D1FB22-A2E0-45A2-A38F-D5FE16322965%40microsoft.com%3E[/uml]
I have also learned to use the chart's setData method, but keep getting runtime errors on it. I believe that it is becuase of the way I am trying to connect it to the spread sheet. This is becuase when I debug I see that the data source for the chart is null. Examples in VB show:
Set ChartSpace1.DataSource = Spreadsheet1
I've tired all I can think of in C#, the most commonly seen is:
axChartSpace1.DataSource = (msdatasrc.DataSource)(object)axSpreadsheet1;
but that throws the "Specified cast is not valid." runtime exception.
I am using the OWC10 not Owc11 I have nothing against using Owc11 other than I cannot figgure out how to referance it correctly. I can referance the OWC10 stuff as I can manipulate the OWC10.axSpreadsheet and .axChartSpace, just cannot bind the chart to the spreadsheet.
Thanks again and I guess I will keep updating this thread as I learn more. Hopefully I won't be the only one contributing! Have a great weekend.