Yago Amat Report post Posted September 27, 2009 Is it possible to insert a chart in one Excel-2007 sheet and use the data from there so it can be dynamic? Thanks Share this post Link to post Share on other sites
fluoronator Report post Posted September 28, 2009 You can do it by using VBA inside of Excel to generate and pass the XML to the chart. Maybe someone will suggest an easier method (but I don't think so...) Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 30, 2009 Hi Yago, You would need to write the VBA code which will generate the data from the excel sheet draw the chart. Share this post Link to post Share on other sites