Referencing the pivot table for the Chart object

[Denver]

Hi

I have just started to use OWC's and I am wondering 2 things

1. How do you reference the data from a Pivot table to display in a
Chart object. ie I have a Pivot table that will be populated by a user
and then I want that table to automatically update a chart present on
the same page.

and

2. Is it possible to set a default view for the Pivot chart, so when
the user opens the web page he will see a set of results automatically?
Rather then having to drag stuff in every time?

please help a new guy out

Thanks in advance

Denver

 

[Denver]

I have sorted the Referencing part, seems that I had a problem with my
VS but it's OK now.

Still interested in the default view though for the pivot report

Cheers

Denver