Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
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 |