Pivot table and Chart view on the same Page

[BizWorld]

I am newb to Office web components. I need to put Chart and Relative data in
Pivot table view on the same asp.net page. I am able to display both of them
on same page but i need to have the relationship between the two so on
updating One, other should be updated itself. I would appreciate if some one
can give me feedback asap. Thanks

 

[RayTheOtherRay]

We start with Excel and build a pivot table (ours is based on an OLAP
cube). We generate the chart as a separate tab in the Excel Workbook.
Using File, Save As... we publish the chart as a web page. This puts
the chart and the pivot table on the same web page. When one is
updated, so is the other.

Hope this helps!
Ray <><