for instance..

Thank you Kelly for taking your time to test this!!!

Unfortunately, not quite the solution I was hoping for.

I thought there might be a more direct approach, this still means having to use a macro to extract those legends and manually replace them, instead of being something automatic for Trados to do, but I will give it a try, any more ideas are welcomed!!!

Thanks!!

Fortunately, all you have to do is click ONCE at pre-translation and click ONCE again at post-translation even you have 1,000 xlsxs.

Unfortunatley, I am not serving free luch any more. Good Luck To You.

..finalized

Claudia Ciaschini

Claudia Ciaschini said:

any more ideas are welcomed!!!

Unfortunately the only way Trados Studio handles these is if the name of the series in your chart is derived from a cell.  I ran three tests.

Default : where I just create the graph a don't rename the series:

Renamed as text : where I just typed in whatever I wanted the series to be called:

Derived from cell reference : where I entered the names into a cell in the spreadsheet and then referenced them in the series:

The only one that works, obviously, is the last one and this is because it's just extracting the cell content for translation and this will automatically be reflected in the chart in the target languages when you save your target files.

Trados Studio ignores all other data. So your best bet, if you can, is to try and encourage your client to use references for these values instead of manually typing in the names.

I will log an enhancement request for this because I think we should extract this info for translation.

Claudia Ciaschini

Claudia Ciaschini said:

any more ideas are welcomed!!!

Unfortunately the only way Trados Studio handles these is if the name of the series in your chart is derived from a cell.  I ran three tests.

Default : where I just create the graph a don't rename the series:

Renamed as text : where I just typed in whatever I wanted the series to be called:

Derived from cell reference : where I entered the names into a cell in the spreadsheet and then referenced them in the series:

The only one that works, obviously, is the last one and this is because it's just extracting the cell content for translation and this will automatically be reflected in the chart in the target languages when you save your target files.

Trados Studio ignores all other data. So your best bet, if you can, is to try and encourage your client to use references for these values instead of manually typing in the names.

I will log an enhancement request for this because I think we should extract this info for translation.

Thank you Paul for logging this enhancement, I will look forward to the  new release!!! 

Rewards,

Claudia