title: Programmatically generating Excel workbook with pivots and charts
body: <p>I need to create a workbook which has a raw data on a sheet and a pivot table on another sheet. The pivot is created from the raw data. Then I need to create a chart with this pivot on the same or new sheet.</p>
  
  <p>How can I do this in C# - and is this possible using VSTO?</p>