I'd like to avoid having to sort and arrange my data, so I'm wondering
if it is possible
to create a category-based line chart with several series, but with
the source data intermixed. The category to which each data point
belongs appears in a cell directly
adjacent to the data cell.

In other words, can I tell Excel that I'd like to chart a several
series from a data
range, and provide a 2nd range which defines the categories of the
corresponding
data points?

For example, my data might be in four categories (calories, speed,
temp, weight) with
five data points in each category, and might appear in the worksheet
like this:

calories 3500
speed 65
temp 98.6
weight 185
calories 4000
speed 68
temp 99.0
weight 170
calories 3320
speed 46
temp 102.5
weight 192
calories 3400
speed 50
temp 98.6
weight 187
calories 4000
speed 68
temp 99.0
weight 170

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.

Thanks,
-Bob
Andover, MA