When I captured setting the values to a non-contiguous range in Spanish
Excel, the string was
"=('Sheet1'!R4C3:R9C3,'Sheet1'!R11C3:R16C3,'Sheet1 '!R18C3:R23:C3)"

I tried changing from using L1C1 to R1C1, so the string seem like they were
exactly the same, but I still got the same error. I must have some other
problem, but I don't know what it is. It works fine in US-English version of
Excel.

"Tushar Mehta" wrote:

What code does the Spanish language version of XL generate if you use
its macro recorder capability to set the chart values?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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.