Chart/Graph Problem with X Axis

[spider8]

HI,
This seems like it should be simple, but I guess I'm just woefully inexperienced with charts, nor am I a very experienced coder either (I can code some though). Here is my data exmple:

Employee Skill A Skill B
Bob 22 18
Mary 19 24

Rating A might be the y axis, and rating b the x axis (the idea is to show where the employees are at being good with both skill ratings) So essentially I need two value axis, but each coordinate on the graph represents an employee and has to be labelled as such. Sounds simple enough to me, but I can't get the scatterplot type to work with all with these three variables. A line chart sort of works, but my only problem with that is that the x axis is a "category axis", not a "value axis" ( It seems like that's the problem to me anyway), so that the x axis only plots points on a relative scale to the values input. I need my x axis scale to look exactly like my y axis scale, no matter what x coordinates are input....
Can anyone help me? I hope this is clear, if it isn't I'm quite sure it's because I evidently stink at charts and graphs.
Thx

 

[dRahme]

Hi, you might check out the thread "Chart Type in VBA" in this formum. A fair amount of stuff about graphs and axes.

 

[spider8]

Thank you for the suggestion That does post does look like it will ehlp me some, at least to better understand what I am working with--thx again