Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting chart series XValues in foreign language
Just a shot in the dark:
Try using FullStop (.) instead of comma (,) Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting chart series XValues in foreign language
That didn't work.
"Sharad" wrote: Just a shot in the dark: Try using FullStop (.) instead of comma (,) Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting chart series XValues in foreign language
Hi Gail,
How do you generate this XValues string in a foreign language? Do I need to use a different separator besides a comma? Hmmm. It *should* work in both cases, if you always use the US-English version. Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting chart series XValues in foreign language
I'm using a Spanish version of Office. It does work in the English version
Office. Thanks, Gail "Stephen Bullen" wrote: Hi Gail, How do you generate this XValues string in a foreign language? Do I need to use a different separator besides a comma? Hmmm. It *should* work in both cases, if you always use the US-English version. Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting chart series XValues in foreign language
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting chart series XValues in foreign language
Hi Gail,
I'm using a Spanish version of Office. It does work in the English version Office. That shouldn't make a difference. Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting chart series XValues in foreign language
It only seems to be a problem with Excel 2000 and non-contiguous ranges. It
works fine in Excel XP. Thanks, Gail "Stephen Bullen" wrote: Hi Gail, I'm using a Spanish version of Office. It does work in the English version Office. That shouldn't make a difference. Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting chart series XValues in foreign language
Hi Gail,
It only seems to be a problem with Excel 2000 and non-contiguous ranges. It works fine in Excel XP. Instead of setting the XValues, Values etc independently, try setting the .FormulaR1C1 for the entire SERIES() formula (record yourself changing it in the formula bar to get the basic syntax). Regards Stephen Bullen Microsoft MVP - Excel www.oaltd.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |