Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2015, 02:07 PM
DatS DatS is offline Changing legends in graph if linked excel file is not available? Windows XP Changing legends in graph if linked excel file is not available? Office 2010 64bit
Novice
Changing legends in graph if linked excel file is not available?
 
Join Date: Oct 2015
Posts: 2
DatS is on a distinguished road
Default Changing legends in graph if linked excel file is not available?

Hello everyone,



I have a problem that is driving me absolutely mental. I am using Word 10.

I am translating a long Word document into another language. The problem is that the documents contains graphs that were (presumably) created in Excel. The client sent me only the Word file, none of the excels files that contain the information displayed in the graphs.

Unfortunately the client is a very busy person who neither understands English very well or seems to know his way around computers, so contacting him for the Excel files is absolutely the last recourse option.

It seems to me like it should be very easy to translate the legends in the graphs, but for some reason I cannot do this. It'll let me change the size, font, etc. but as for changing the text itself, not a chance.

Here's an example:



ALL that I need to do is to translate the legends on the right. I do not need to update the data or anything. Nor does this have to be updatable later because it'll be published in pdf form online.

I'm sure this question is pretty dumb, but I'd really appreacite if someone could give me some advicde how to do this.
Reply With Quote
  #2  
Old 10-18-2015, 04:57 PM
macropod's Avatar
macropod macropod is offline Changing legends in graph if linked excel file is not available? Windows 7 64bit Changing legends in graph if linked excel file is not available? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Have you established that the graphs are, in fact, linked to an external Excel file? If they are, that's the only place the data can be edited. If they've just been inserted into Word as chart objects, double-clicking on them should open them for editing, in which case you should be able to access the data behind the charts and change the legend. Of course, if they've been inserted as images, that option won't be available (depending on the image format, you may be able to ungroup the elements and edit them individually).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-18-2015, 05:10 PM
DatS DatS is offline Changing legends in graph if linked excel file is not available? Windows XP Changing legends in graph if linked excel file is not available? Office 2010 64bit
Novice
Changing legends in graph if linked excel file is not available?
 
Join Date: Oct 2015
Posts: 2
DatS is on a distinguished road
Default

Yes, I'm sure they're linked to external Excel files. Double-clicking allows me to edit their appearance, but not the actual data. Would "breaking" the links help at all?
Reply With Quote
  #4  
Old 10-18-2015, 05:44 PM
macropod's Avatar
macropod macropod is offline Changing legends in graph if linked excel file is not available? Windows 7 64bit Changing legends in graph if linked excel file is not available? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Unlinking will leave you with the chart, but you still won't be able to edit the legend text. The only way to edit the data is by accessing the data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing legends in graph if linked excel file is not available? Changing Field Links in a Word Document from one excel file to another Fed77 Word VBA 9 07-08-2015 02:24 AM
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM
Graph disappers when I save file with a new name des Excel 0 04-18-2014 10:37 AM
Changing legends in graph if linked excel file is not available? Linked Excel file not auto-updating in Word like it should, help needed Bryan@FIC Word 1 05-29-2012 07:35 AM
Excel File as Linked Object in Word jfitch Word 0 03-18-2010 11:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:28 AM.


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