3D plots

[Pete]

I have 3D surface a chart, such that there are about 40
series all of which use a common X axis text column. hence
the Source Data Range reads: =normalised!$B$10:$AL$727
and an example series would be:
Name:=normalised!$C$10
Values:=normalised!$C$10:$C$727
Category (X) axis labels: =normalised!$B$10:$B$727
so for each series replace C with D,E,F etc...

I now want it to look at more rows, i.e.
the Source Data Range reads: =normalised!$B$10:$AL$840

but if I make this change it mucks everything up such that
there are only three series, the first one for examples
looks like this:
Name=normalised!$AJ$10:$AJ$839
Values=normalised!$AJ$840
Category (X) axis labels=normalised!$B$8400:$AI$840

Is this a known bug, or is there some way I could get
around it? - Of course I could change the value manually
for each of my original 40 series - but there must be a
better way.
here is an example of the source table
B C D E F...AI
10 Flight AB1 (26)AB3 (21)AB3 (22)...
11 SNZA671-85-1 -0.466 -0.429 -0.603
12 SNZA671-85-2 -0.350 -0.499 -0.456
13 SNZA671-85-3 -0.658 -0.397 -0.500
14 SNZA671-85-5 -0.411 -0.399 -0.455
15 SNZA671-85-6 -0.680 -0.484
16 SNZA671-86-11-0.479 -0.414
17 SNZA671-86-15-0.485 -0.332 -0.531
18 ....
840

 

[Pete]

I think I worked out how to do it - change the chart
location to within the worksheet (rather than a separate
sheet) you can then dray the blue series box to the desire
range, then reset the chart location to a new sheet.
Pete

 

[Jon Peltier]

Pete -

That's a good way to do it, which will prevent the problem you saw. I
think you have a value in the added range which is text, not a number.
It could well be in AI840, AI839, or AJ839 judging from the Name and X
Values you posted. If these new cells were numbers, it should have
worked fine.

- Jon