We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Chart is not getting refreshed in Powerpoint presentation

Thread ID:

Created:

Updated:

Platform:

Replies:

149634 Dec 4,2019 08:23 AM UTC Dec 9,2019 11:29 AM UTC ASP.NET Web Forms 3
loading
Tags: Presentation
Tayyab Hussain
Asked On December 4, 2019 08:23 AM UTC

Good Day,

I am trying to use Syncfusion.Presentation library in order to refresh a chart in Microsoft Powerpoint presentation (linked with Microsoft Excel) whenever data changes in Microsoft Excel. The code runs fins and produce the output file but doesn't refresh the chart. Instead, in the output file, it shows the chart empty. After initial analysis, i found that, output file created by code doesn't identify the range of data correctly. That's why, chart is being shown empty e.g. if in original file data range for chart is A12:C22, in the output file, this range is not being identified correctly and chart is shown as an empty chart. 
Code is given below

               //Opens the Presentation
                IPresentation pptxDoc = Presentation.Open(@"Path of original presentation");
                
                

                //Gets the first slide
                ISlide slide = pptxDoc.Slides[1];

                //Gets the chart in slide
                IPresentationChart chart = slide.Shapes[10] as IPresentationChart;

                //Refreshes the chart
                chart.Refresh();
                
                  
                //Saves the Presentation
                pptxDoc.Save(@"path of output file.");

                //Closes the Presentation
                pptxDoc.Close();

                MessageBox.Show("Done"); 

Vijayasurya Anandhan [Syncfusion]
Replied On December 6, 2019 01:02 PM UTC

Hi Tayyab,

Thank you for contacting Syncfusion support.

At present our Essential PowerPoint presentation Library does not have support to the feature
Data changes in Microsoft Excel should automatically refresh the chart in the presentation slide and also we do not have any immediate plans to implement this feature.

Please let us know if you have any questions.

Regards,
Vijayasurya A


Tayyab Hussain
Replied On December 8, 2019 06:54 AM UTC

Good Day,

Thank you for your reply and clarification.

However, just to clear one thing, i am not expecting that change in source data present in Microsoft Excel should "automatically" update the chart in presentation. 

What is required that chart in presentation should be updated upon an event e.g. timer event. I am able to grab the chart in presentation using Syncfusion library and refresh it in an event but it doesn't show the updated linked range upon refresh and shows an empty chart.



Ramaraj Marimuthu [Syncfusion]
Replied On December 9, 2019 11:29 AM UTC

Hi Tayyab,

Thank you for the update.

We have considered your requirement and modified the feature title as “Update the chart data from linked Excel sheet on refresh” and as we mentioned earlier currently we do not have any immediate plans to implement this feature in our end.

Please let us know if you need any further assistances.

Regards,
Ramaraj Marimuthu. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon