Inserting only the excel chart as OLE object in a ppt

[sbommire]

Hi,<br>

I am using aspose.slides. I need to create dynamic chart(chart changes
as the reated data changes) on a ppt slide. Right now, I am creating in
a excel sheet and copying the entire sheet on to the ppt by reading the
entire sheet into a byte stream. Now, I need to embed only the chart on
the ppt, but not the entire sheet.



Is there any other way I can create a dynamic chart on a ppt. Can I do
it without using a excel workbook. That is, can I creata a chart on ppt
and change the data pertaining to it so that the changes are reflected
in the chart using aspose.slides?

Can you suggest what I can do?

[shakeel.faiz]

Dear sbommire,

Please create your chart in new sheet. Select your data and then use Insert -- > Chart wizard in excel, at step 4 select As new sheet:

Doing so, when you will insert your chart from bytestream, it will only show the chart not the sheet. Please see the screen shot. I will also attach the samle excel file in new post.

[shakeel.faiz]

And excel file.

[zc0000]

But how to do it programatically ??? Please response quickly , thank you !!

[shakeel.faiz]

Aspose.Slides will only allow you to insert/delete the chart, if you want to manipulate the chart, you will need Aspose.Cells.

For code example, the following thread has a code that reads the excel chart from ppt and manipulate it and write it back.

http://www.aspose.com/community/forums/72379/showthread.aspx