T
TheRook
Hopefuuly I can explain this one correctly!!!
I currently have a spreadsheet that contains the following:
Column A 'Scrap reason'
Column B 'Qty Scrapped'
Column C 'Tonnage scrapped'
From this I need to analyse the top scrappers for both Qty & Tonnage in %age.
I have used the RANK function to be able to do this.
What I am wanting to do on the chart is have the %age on the left with the
rankings going along the bottom 1 to 32, with 2 results against each ranking
ie in No. 1 the top tonnage % and the to qty %. The only way I have been
able to do this is so that the data is sorted by rank i.e 1,1,2,2,3,3 and so
on then use 1 data source. The problem with this is that the bars are the
same colour and cannot ne identified as tonnage or items.
Can anyone help. I need to report this by 16:45 GMT and am fast running out
of time!!!!!!!!
The Rook
I currently have a spreadsheet that contains the following:
Column A 'Scrap reason'
Column B 'Qty Scrapped'
Column C 'Tonnage scrapped'
From this I need to analyse the top scrappers for both Qty & Tonnage in %age.
I have used the RANK function to be able to do this.
What I am wanting to do on the chart is have the %age on the left with the
rankings going along the bottom 1 to 32, with 2 results against each ranking
ie in No. 1 the top tonnage % and the to qty %. The only way I have been
able to do this is so that the data is sorted by rank i.e 1,1,2,2,3,3 and so
on then use 1 data source. The problem with this is that the bars are the
same colour and cannot ne identified as tonnage or items.
Can anyone help. I need to report this by 16:45 GMT and am fast running out
of time!!!!!!!!
The Rook