On Thu, 26 Apr 2007, in microsoft.public.excel.charting,
Bob said:
For example, my data might be in four categories (calories, speed,
temp, weight) with
five data points in each category,

Previously, I've solved this by sorting into four separate regions,
then define the
chart's four series out of each region.

But this doesn't scale easily, as I will be routinely creating charts
containing
over 30,000 data points distributed among 14 categories.

If you populated the column to left with a formula like
IF(B3="calories",A2+1,A2) you would have a range like so:

A B C
1 calories 3500
1 speed 65
1 temp 98.6
1 weight 185
2 calories 4000
2 speed 68
2 temp 99
2 weight 170
3 calories 3320
3 speed 46
3 temp 102.5
3 weight 192
4 calories 3400
4 speed 50
4 temp 98.6
4 weight 187
5 calories 4000
5 speed 68
5 temp 99
5 weight 170

Can you make a pivot table or pivot chart out of that to look like this?

A calories speed temp weight
1 3500 65 98.6 185
2 4000 68 99 170
3 3320 46 102.5 192
4 3400 50 98.6 187
5 4000 68 99 170
----------------------------------------
18220 297 497.7 904

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.