Create Multi Series Chart w/ Data in Database Form

[Strother19900]

Hello,

I have information in database form (example below), I need to make a multi series scatter with straight lines plot from this information.

So I need a method to make the name of each series the name and then for that series plot the x and y values....

Example:


[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]X Axis[/TD]
[TD]Y Axis[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]1[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]2[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]3[/TD]
[TD]10000[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]4[/TD]
[TD]100000[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]1[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD]2[/TD]
[TD]10000[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1[/TD]
[TD]12000[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]2[/TD]
[TD]14000[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]3[/TD]
[TD]25000[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]4[/TD]
[TD]30000[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]5[/TD]
[TD]40000[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]6[/TD]
[TD]20000[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]7[/TD]
[TD]25000[/TD]
[/TR]
[TR]
[TD]......[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Any help would be much appreciated!

Thanks!!

 

[Jon Peltier]

I've written two tutorials to handle this situation, one using VBA, the other using formulas.

VBA to Split Data Range into Multiple Chart Series

Split Data Range into Multiple Chart Series without VBA