R
Roger Dunn
I've had a problem for quite sometime setting the x-axis range for day of week,
for non-English enabled(european) Windows.
Here are the steps to reproduce this. Windows XP, Office XP/2000
You can do this on a fully English version of Windows and office.
1) Go to control panel
2) Select Regional and Language Options.
3) Choose French (Belgium) (others suffice, but I tested with this setting)
4) Click ok.
5) Start Excel.
6) Enter 7 values down a column (100, 200, 300, 400, 500, 250, 230)
7) Select the range.
8) Click Chart Wizard
9) Click Finish
10) Click inside plot area (gray area)
11) Right-Click, select Source Data
12) Click Series Tab
13) Enter in the Category (X) axis labels edit field: 2,3,4,5,6,7,1
14) Click OK ( you get error msg )
Close Excel.
Restore your language settings and do the steps again, it works.
for non-English enabled(european) Windows.
Here are the steps to reproduce this. Windows XP, Office XP/2000
You can do this on a fully English version of Windows and office.
1) Go to control panel
2) Select Regional and Language Options.
3) Choose French (Belgium) (others suffice, but I tested with this setting)
4) Click ok.
5) Start Excel.
6) Enter 7 values down a column (100, 200, 300, 400, 500, 250, 230)
7) Select the range.
8) Click Chart Wizard
9) Click Finish
10) Click inside plot area (gray area)
11) Right-Click, select Source Data
12) Click Series Tab
13) Enter in the Category (X) axis labels edit field: 2,3,4,5,6,7,1
14) Click OK ( you get error msg )
Close Excel.
Restore your language settings and do the steps again, it works.