title: Is it possible to embed an excel pivot graph as a webpart?
body: <p>I have published my Excel workbook (which is one sheet with pivot-data linked to SQL Server and one sheet with stacked graph based on that data) to sharepoint 2010, and can view the chart fine via excel services xlviewer.aspx</p>
  
  <p>I would now like to have the chart shows on our team's front page, by embedding a webpart to show the graph.</p>
  
  <p>I've been able to achieve this by adding a Page Viewer part (IFrame) that links to the workbook, but this doesn't seem ideal (it requires setting the height, and it shows all the extra toolbars etc.)</p>
  
  <p>I tried to insert a Chart web part linked to the excel workbook, but I do not know how to specifify the range name - I tried to use the same data range as in the pivot chart in my workbook ([Workbook.xlsx]WorkSheet!PivotTable), but I get the error:</p>
  
  <pre><code>Exception has been thrown by the target of an invocation.
  </code></pre>
  
  <p>Does anyone know if what I want it possible?</p>