Hi All,

Something I wanted to run by you Excel gurus before drastic measures are implemented!

I have a Word template that forms the basis of a monthly report. The template has a number of bar charts (showing one data sries) linked to a separate Excel file and charts using the 'Paste Special/Paste Link' facility in word. The idea is that I update my Excel spreadsheet, open the Word template, refresh the charts to show the newly added data in Excel and then after saving the Word template, I can create a new Word document from it for the next monthly report. Everything works just as it should up until now.

Recently, I was asked to amend about six charts to include a new second data series. So I updated the Excel files and their charts to achieve this but the corresponding chart, when refreshed in the Word template, continues only to show the original first data series, not the two. Before I go ahead and delete these charts from Word and re-insert the new 2-series charts, I wondered if anyone knows if the new 2-series charts should actually update in Word from the Excel file.

It's not something I've been asked to do before and I can't seem to find a definitive answer from Google, probably because I'm not phrasing the question correctly.

Many thanks.