So, we have excel services turned on in our SP 2010 site and we are able to successfully show excel charts in our webpart page. Currently whenever there is a change to the data in excel that affects the chart, we would have to upload the new excel and then re-save from within SP for the chart to refresh.
The goal is to be able to upload the excel file with the changes and for the chart in SharePoint to automatically refresh without having to re-save the file.
is this possible?
Thanks for any help you can provide.