Excel 2007 Scatter Charts

[Reimer]

Hi guys/gals,
I need help again. A user wants to make a Scatter Chart with three groupings -one for each Code.
Column A has Code (ABC, DEF or xyz).
Column B has Years of Service.
Column C has Rate.
Row 1 has headings.
I tried posting yesterday but had trouble. This morning I checked and the workbook was HUGE -so i deleted the unused rows and will try to attach it again.

Any suggestions would help.

Thanks

[HansV]

Excel normally expects each series to have its own column, so you have to add the series manually. In the attached version, you can see how the series are defined by clicking on one of them and looking at the formula bar.

ScatterChart.xlsx

[Reimer]

Hans,

Thanks. I will take a look at it. When the User gets in this morning I will show it to him. Thank you for your time.

[Reimer]

Hans,

The user is VERY happy!
He was able to make the full sized version into exactly what he wanted.
He said he owes me big time - I explained he owes YOU Big Time (and gave him the URL to Eileen's).

Thanks again (and again and again, etc)

[HansV]

I'm glad it worked!

[Reimer]

I bet not as glad as he was. It was actually rather funny how excited he was.