Hi Omar_aa,

i am writing a program in vb.net that uses pivotchart with backend sql
server........i.e.the data is fed into the pivot chart through a query
from
the sql server........now i want to use my stored porcedure to populate
my
pivot chart........is there anyways that i will be able to use stored
procedure to populate that pivot chart...........is there anyone who can
guide me in this regard..
Best Regards
Omar_aa

I don't know how to update an Excel Pivot Chart using a stored procedure. I
doubt that there is a SQL command to get Excel to update a Pivot Chart .

Of course you can use vb.net to open the Excel workbook and update the pivot
chart. Just use the RefreshTable of the PivotTable object in Excel.

However, what I normally do is set the Pivot Chart options in Excel to
update data on file open. Then you just need to open the workbook and the
data will update automatically.

Ed Ferrero
www.edferrero.com