Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2016, 10:24 AM
GregL GregL is offline Embedded Excel charts refresh only data values, not which data points (rows) are included Windows 7 64bit Embedded Excel charts refresh only data values, not which data points (rows) are included Office 2010 32bit
Novice
Embedded Excel charts refresh only data values, not which data points (rows) are included
 
Join Date: Jun 2011
Posts: 12
GregL is on a distinguished road
Default Embedded Excel charts refresh only data values, not which data points (rows) are included

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfering External Data from charts into Excel iforocx22 Excel 0 03-20-2016 05:27 PM
Charts - formatting dates in a data table - Excel 2013 IanGUK1 Excel 0 12-04-2014 01:44 AM
Need 2 embedded charts to update upon editing data in one SRichardson Excel 1 02-19-2014 12:44 AM
Edit Data Source- Linking template charts to new data lbf PowerPoint 0 10-28-2011 12:19 PM
Embedded Excel charts refresh only data values, not which data points (rows) are included Link data from embedded excel sheet rwbarrett Word 1 05-27-2011 02:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft