Thread: Setting chart series XValues in foreign language
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
  
Posts: 1,071
Default Setting chart series XValues in foreign language
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.

Reply With QuoteReply With Quote