Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbooks run on foreign language computers | Excel Worksheet Functions | |||
Insertion of formulas in foreign language in english version of ex | Excel Discussion (Misc queries) | |||
Excel in a foreign language | Excel Discussion (Misc queries) | |||
Problem adding Series XValues to Chart using VBA | Charts and Charting in Excel | |||
Chart Setting Xvalues | Excel Programming |