How do I edit legend entries in Excel? Autor vlákna: Jana Teteris
| Jana Teteris Velká Británie Local time: 17:27 lotyština -> angličtina + ...
I am working on a translation that is in Excel format and have come across a couple of 'legend entries' that need to be translated. Unfortunately I don't have much experience with Excel, and can't work out how to edit (ie. translate) these entries. Can anyone help? | | | Natalie Polsko Local time: 18:27 Člen (2002) angličtina -> ruština + ... MODERÁTOR SITE LOCALIZER
Have you tried double-clicking at the legends? This way you should enter the edit mode. | | | Jana Teteris Velká Británie Local time: 17:27 lotyština -> angličtina + ... AUTOR TÉMATU
That's the first thing I tried and it doesn't work. | | | Victor Potapov Ruská federace Local time: 19:27 angličtina -> ruština + ... Or else try editing the row (column?) headings in the "source data" area... | Dec 26, 2005 |
Hi Jana, You can double-click on the legend entries as Natalie mentioned earlier - or you can go into the source area of the chart/graph/diagram (it is one of the tabs in "chart properties" window - or you can find this data area in a number of other ways). The idea is to change/translate the headings of the columns or rows (depending on how your data is arranged in the source table) - and theoretically Excel should change the legend captions in the chart using this da... See more Hi Jana, You can double-click on the legend entries as Natalie mentioned earlier - or you can go into the source area of the chart/graph/diagram (it is one of the tabs in "chart properties" window - or you can find this data area in a number of other ways). The idea is to change/translate the headings of the columns or rows (depending on how your data is arranged in the source table) - and theoretically Excel should change the legend captions in the chart using this data area. Hope this helps! Victor. Jana Teteris wrote: I am working on a translation that is in Excel format and have come across a couple of 'legend entries' that need to be translated. Unfortunately I don't have much experience with Excel, and can't work out how to edit (ie. translate) these entries. Can anyone help? ▲ Collapse | |
|
|
Natalie Polsko Local time: 18:27 Člen (2002) angličtina -> ruština + ... MODERÁTOR SITE LOCALIZER
Then could you please provide more details where this legend is in your file? I assumed it is a legend to a figure/chart but in case it is not, it may be in the headers/footers or maybe in comments. Is it greyed out? Try going to edit > headers and footers or to edit > comments in order to find out where these legends are located. | | | Jana Teteris Velká Británie Local time: 17:27 lotyština -> angličtina + ... AUTOR TÉMATU Middle of the sheet | Dec 26, 2005 |
Natalie wrote: Then could you please provide more details where this legend is in your file? I assumed it is a legend to a figure/chart but in case it is not, it may be in the headers/footers or maybe in comments. Is it greyed out? Try going to edit > headers and footers or to edit > comments in order to find out where these legends are located. When I double-click on the legend then a formatting window appears, which lets me change the font, colour etc. but not the actual text. The legend appears to the right of a graph in the middle of the sheet. When I click on 'chart options' under the 'charts' tab I can change the title & axes of the graph, but not the legend as the original text doesn't appear. I also checked under headers-footers & comments, but the legend doesn't appear there either. More confused than ever now... | | | Editing Excel legend | Dec 26, 2005 |
Jana Teteris wrote: More confused than ever now... Jana, I am assuming that the Excel chart is within Word or some other word processing package. If that is the case, whether you can change the legend depends on (i) whether the chart is still linked to the Excel file on which it is based or (ii) whether the chart has simply been embedded into the Word file. If the latter is the case, you cannot change the legend. You need the original Excel data sheet to change the legend. If (i) is the case, when you click on the chart it should convert to the Excel spreadsheet, but still within a frame in the Word file. At the bottom of the frame, there should be tabs labeled ‘chart’, ‘sheet 1’, sheet 2’ etc. Click on one of the ‘sheets’. That should give you the accrual Excel data. In one of the ‘sheets’ (usually the first one), you should be able to see the labels for the legend in one of the columns. You simply over-write that in the target language and click on the ‘chart’ tab at the bottom. Then click outside the frame, so that the chart reappears in its normal place in the Word file. The legend should have changed. Best of luck. | | | Natalie Polsko Local time: 18:27 Člen (2002) angličtina -> ruština + ... MODERÁTOR SITE LOCALIZER Dataset titles | Dec 26, 2005 |
Hi Jana, 1) Right-click on white space of the image, somewhere above the legends (so that the whole graph is selected) and then choose 'source data' (this option is the third from the top). 2) Choose the 'series' tab, and in the opened window you'll see a small copy of the graph, and below it the list of the data series (to the left) and the titles of the series (to the right). The first series will be chosen by default, and it's title shown to the right. <... See more Hi Jana, 1) Right-click on white space of the image, somewhere above the legends (so that the whole graph is selected) and then choose 'source data' (this option is the third from the top). 2) Choose the 'series' tab, and in the opened window you'll see a small copy of the graph, and below it the list of the data series (to the left) and the titles of the series (to the right). The first series will be chosen by default, and it's title shown to the right. To see (and translate) the other titles you should choose the corresponding series from the list in the left part of the window. HTH, Natalia ▲ Collapse | |
|
|
Jana Teteris Velká Británie Local time: 17:27 lotyština -> angličtina + ... AUTOR TÉMATU Thankyou Natalie! | Dec 26, 2005 |
Natalie wrote: Hi Jana, 1) Right-click on white space of the image, somewhere above the legends (so that the whole graph is selected) and then choose 'source data' (this option is the third from the top). 2) Choose the 'series' tab, and in the opened window you'll see a small copy of the graph, and below it the list of the data series (to the left) and the titles of the series (to the right). The first series will be chosen by default, and it's title shown to the right. To see (and translate) the other titles you should choose the corresponding series from the list in the left part of the window. HTH, Natalia A public thankyou to Natalie! She very kindly took a look at the file which I e-mailed to her and managed to solve my dilemma. | | | pmakinen Local time: 09:27 Člen (2005) chorvatština -> angličtina + ... I Like These Replies | Mar 28, 2007 |
But what does one do when the references to other Excel files are broken (i.e., the client did not preserve the directory structure and just sent a heap of spreadsheets in no discernible order)? Excel will not let you exit the Legend -> Series dialog box if *any* of the references in the dialog box are broken... Am I really left with Photoshop/Corel Draw as my only option in this case? | | | Use Format Data Series or Format Trend Lines or | Dec 13, 2013 |
Changing data labels This is can be done in the original data, but you can also right click on your data line on the chart, select ‘Select Data…’, in the box labeled ‘Name’. Change labels of trendlines Right click on trendline, select Format trendline, Select Options and you can change the name from automatic to custom and type in the new name. | | | Maxime Bujakov Francie Local time: 18:27 francouzština -> angličtina + ... same problem - external links | Oct 26, 2016 |
pmakinen wrote: But what does one do when the references to other Excel files are broken (i.e., the client did not preserve the directory structure and just sent a heap of spreadsheets in no discernible order)? Excel will not let you exit the Legend -> Series dialog box if *any* of the references in the dialog box are broken... Yell at the customer Seriously, thank you for mentioning this case - I suffer from the same | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » How do I edit legend entries in Excel? Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
| Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |