Creating a Chart with a Secondary X-Axis, with a twist maybe?

[Refresher]

Hi,

Is there a way with Excel (both 2003 and 2007) to have a graph with two
x-axis, where the first is a primary axis and the second is a repeated axis
associated with the primary axis? For example, let's say on the Y-Axis I have
output Power. The primary x-axis I have temperature, let's say 0, 32, 100,
150. So I am plotting temperature vs. output power. However, I want a
secondary x-axis that contains part serial numbers, let's say AA, BB, CC, DD.
What I want to do is, for every temperature, plot a line with power output
values from each serial number. So I will have 4 lines, one right after the
other. Here is a text example, although it doesn't do much justice:

6 |
|
5 |
|
4 |
|
3 |
|
2 |
|
1 |
|----------------|---------------|---------------|----------------|
AA BB CC DD AA BB CC DD AA BB CC DD AA BB CC DD

0 32 100 150


Thanks.

 

[Jon Peltier]

Arrange your data like this:

0 32 100 150
0 AA 1
BB 2
CC 3
DD 4
32 AA 1
BB 2
CC 3
DD 4
100 AA 1
BB 2
CC 3
DD 4
150 AA 1
BB 2
CC 3
DD 4

Any cells without anything visible should be completely blank. If necessary,
select the cells and press Delete.

Select the entire data range, and make a line chart, with series in columns.

- Jon