LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 205
Default 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


 
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 02:35 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"