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]

name

position

rate

satus

name1

dir

80

won

name2

acc

60

lost

name3

***

20

pending

position

won

lost

pending

name4

hr

45

won

dir

2

1

1

name5

dir

85

lost

acc

1

2

1

name6

acc

55

pending

***

1

1

1

name7

***

25

won

hr

1

1

1

name8

hr

40

lost

name9

dir

90

pending

name10

acc

55

won

name11

***

30

lost

easy to make a stacked bar chart

name12

hr

45

pending

with dir acc *** hr on the x axis

name13

dir

80

won

name14

acc

60

lost

what is rate per account ?

eg dir rates are 80,85,90,80

you may need to consider

2 identically sized charts

one on top of the other

<colgroup><col><col span="12"></colgroup><tbody>
</tbody>