I need to use chart web part in SP 2010 and I am having an excel file with few columns and end user uploads this excel list with updated values in the columns every week.
I need to generate a chart based on these values within the excel which is residing in the document library.
I am stuck with the approach, how to read the excel file and its columns that's consumed by chart web part in order to generate a pie/line chart. ?