I have a Word 2013 template with Excel 2013 chartes embedded. When I update the data in Excel so that the charts reflect new data, and then refresh them in Word (Design > Refresh Data), they refresh fine.
HOWEVER, if I also change which rows of data are included in the chart, so that for example the September column is omitted while the April column added back after being previously excluded, the chart looks correct in Excel; the chart in Excel now has a column for April and no longer has a column for September, as expected. But when I refresh the embedded Excel charts in Word, I get a strange result:
- The April column does not appear, and the September column does not go away (the September column now shows a 0 value).
- Yet for the columns that were there when I pasted the chart into Word and are still there in Excel, those columns are refreshed with new data values as expected. So for example the December column, if it was there before and is still there, changes height to reflect the new data value. So it IS refreshing the data point values; it's just not updating which data points are included.
Is there any way to make the embedded Excel charts refresh to look the same as they do in Excel?
BTW I tried saving the Excel file before refreshing, but got the same result.