LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Setting chart series XValues in foreign language

I am trying to set the series for a chart.

On an English operating System, I set XValues to
"=('Sheet1'!R5C5:R10C5,'Sheet1'!R12C5:R17C5,'Sheet 1'!R19C5:R24C5,'Sheet1'!R26C5:R31C5)" and that works fine.

On a Spanish operating System, I set XValues to
"=('test'!L4C1:L9C2,'test'!L11C1:L16C2,'test'!L18C 1:L23C2,'test'!L25C1:L30C2)".
I get the following error, "(0x800A03EC): La fórmula introducida contiene un
error. Intente lo siguiente:

ۢ Compruebe que se han incluido todos los par̩ntesis y argumentos necesarios.
€¢ Para obtener ayuda al usar una función, haga clic en Función en el menú
Insertar.
€¢ Si incluyó una referencia a otra hoja o libro, compruebe que la referencia
es correcta.
€¢ Si no desea introducir una fórmula, evite usar el signo igual (=), el
signo menos (-) o iniciar la entrada con una comilla (').
€¢ Para más información acerca de los problemas comunes de fórmulas, haga
clic en Ayuda.

How do you generate this XValues string in a foreign language? Do I need to
use a different separator besides a comma?

Thanks in advance for any help you can give me.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Workbooks run on foreign language computers murray-m Excel Worksheet Functions 0 October 27th 06 05:38 AM
Insertion of formulas in foreign language in english version of ex Pedro Excel Discussion (Misc queries) 0 May 3rd 06 12:48 AM
Excel in a foreign language nsv Excel Discussion (Misc queries) 1 February 16th 06 02:34 PM
Problem adding Series XValues to Chart using VBA Sean Curry Charts and Charting in Excel 0 March 14th 05 12:18 AM
Chart Setting Xvalues Nigel[_8_] Excel Programming 1 December 24th 03 08:10 AM


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"