Text on the x Axis of a Scater diagram (Line graph does not work)

[Bondi]

Hi All,

I am hoping someone can please help me from pulling all my hair out over this Excel graph issue.

The problem is like many others out there I am trying to create a graph with the following criteria.

Data set

Company name Company position Rate per hour Won/lost/pending

Jimmy choo Director 80 Won
Jimmy Choo Accountant 60 Won
Jimmy Choo Assistant 20 Won
Jimmy Choo HR 40 Won
King fisher Director 60 Lost
King Fisher Accountant 40 Lost
King Fisher Assistant 25 Lost
King Fisher HR 30 Lost
SA breweries Director 100 Pending
SA breweries Assistant 35 Pending
SA breweries Accountant 50 Pending
SA breweries HR 38 Pending
Rolls Royce ect.
Virgin Media ect.

So what I need is:
1) Company Position on the x Axis in text
2) Y value is the Rate per account
3) Won/Lost/ Pending is the series to appear in the Legend
2) Company Name will pop up in the Data label


And below is an example of how I need it to look.



Y
100

• Jimmy Choo
50 • Kingfisher •Rolls Royce
• SA Brew
• Kingfisher
0 x axis
Director Accountant Assistant HR

Legend • Won • Lost • Pending




I have searched Google for the answer and the only answer is a Line graph by this does not work if my number of companies exceeds the number of positions. So If have more than 4 Companies with only the 4 positions it doesn't work



Much appreciated

Many thanks

Chris

 

[oldbrewer]

[TABLE="width: 847"]
<colgroup><col><col span="12"></colgroup><tbody>[TR]
[TD]name[/TD]
[TD]position[/TD]
[TD]rate[/TD]
[TD]satus[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name1[/TD]
[TD]dir[/TD]
[TD="align: right"]80[/TD]
[TD]won[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name2[/TD]
[TD]acc[/TD]
[TD="align: right"]60[/TD]
[TD]lost[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name3[/TD]
[TD]***[/TD]
[TD="align: right"]20[/TD]
[TD]pending[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]position[/TD]
[TD]won[/TD]
[TD]lost[/TD]
[TD]pending[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name4[/TD]
[TD]hr[/TD]
[TD="align: right"]45[/TD]
[TD]won[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]dir[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name5[/TD]
[TD]dir[/TD]
[TD="align: right"]85[/TD]
[TD]lost[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]acc[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name6[/TD]
[TD]acc[/TD]
[TD="align: right"]55[/TD]
[TD]pending[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]***[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name7[/TD]
[TD]***[/TD]
[TD="align: right"]25[/TD]
[TD]won[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]hr[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name8[/TD]
[TD]hr[/TD]
[TD="align: right"]40[/TD]
[TD]lost[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name9[/TD]
[TD]dir[/TD]
[TD="align: right"]90[/TD]
[TD]pending[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name10[/TD]
[TD]acc[/TD]
[TD="align: right"]55[/TD]
[TD]won[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name11[/TD]
[TD]***[/TD]
[TD="align: right"]30[/TD]
[TD]lost[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]easy to make a stacked bar chart[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name12[/TD]
[TD]hr[/TD]
[TD="align: right"]45[/TD]
[TD]pending[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]with dir acc *** hr on the x axis[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name13[/TD]
[TD]dir[/TD]
[TD="align: right"]80[/TD]
[TD]won[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name14[/TD]
[TD]acc[/TD]
[TD="align: right"]60[/TD]
[TD]lost[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]what is rate per account ?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]eg dir rates are 80,85,90,80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]you may need to consider[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]2 identically sized charts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]one on top of the other[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]