Excel Chart, 1 X value per Series, Many Y values, possible??

[MatthewBell]

Hi, thanks for looking

I need to plot data from a spreadsheet. At present I have:
A cell eg F1, with series name (part No) in it
A cell eg F3, with an X value (A statistic relating to a batch)
20 Y values, in cells F6:F25 (measurements for the batch)

I have 8 series at present (in 8rows) but will need to add more

I'd like a chart plotting the 20 Y values against the single X value. This will be a series forming a vertical line of points. Then I will have 7 more series of the same nature.

Is this possible?

 

[SkipVought]

Hi, you need 20 x-values (all the same)

Plot on x-y scatter.

Skip,

_{[red]Be Advised![/red] Coeds studying ancient Egyptian plumbing, might be known as...
Pharaoh Faucet Majors}