Em Andamento

EXCEL - DYNAMIC BAR GRAPH - repost 2

THE ATTACHED FILE HAS 2 TABLES TITLED TABLE ONE AND TABLE TWO

THE DATA DISPLAYED IN TABLE TWO FEEDS OFF CALCULATIONS IN TABLE ONE – TABLE ONE WILL BE MANUALLY UPDATED WEEK BY WEEK WHICH IN TURN WILL UPDATE TABLE TWO

I NEED A DYNAMIC GRAPH THAT READS THE DATA DISPLAYED IN TABLE TWO

THE 'X' AXIS (HORIZONTAL) NEEDS TO READ….

OVERALL, SERVICE FROM SUPPORT TEAM, TECHNICAL SUPPORT, WORK SCHEDULING, SERVICE DELIVERY

THE 'Y' AXIS (VERTICAL) NEEDS TO READ

EXCELLENT

VERY GOOD

GOOD

AVERAGE

POOR

THE VALUE OF THE 'Y' AXIS SERIES IS BASED ON A NUMBER IN COLUMN B OF TABLE TWO - AS YOU WILL SEE ‘EXCELLENT’ CURRENT LY HAS A VALUE OF 170

VERY GOOD CURRENTY HAS A VALUE OF 136 AND SO ON

AS THE DATA IN TABLE ONE IS MANUALLY UPDATED THESE VALUES IN TABLE TWO WILL AUTOMATICALLY UPDATE AND THEREFOR SO WILL OUR DYNAMIC GRAPH

SO ON THE DYNAMIC BAR GRAPH CURRENTLY THE BAR FOR 'OVERALL' SHOULD GO TO A VALUE OF 151 WHICH SHOULD PUT THE BAR ABOVE ‘VERY GOOD’ AS THIS HAS A VALUE OF 136 AND THE BAR SHOULD ALSO BE BELOW ‘EXCELLENT’ AS THIS HAS A VALUE OF 70

DYANMIC GRAPH IS TO BE INSERTED INTO SHEET 1 WORKSHEET

Habilidades: Excel

Ver mais: x-axis, service dynamic, graph this data, graph the data, graph c, data on a graph, data in a graph, c graph, as graph, technical data sheet, excel service, excel column update, dynamic 2013, read excel file sheet, automatically update worksheet, turn dynamic, vertical excel file horizontal file, scheduling excel, turn excel, horizontal bar graph, horizontal bar, horizontal graph, file series excel, excel column column, dynamic table

Acerca do Empregador:
( 32 comentários ) MALAGA, Australia

ID do Projeto: #5107487

Premiar a:

dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi Mais

$45 AUD em 3 dias
(15 Avaliações)
4.7

2 freelancers are bidding on average $38 for this job

kiyasmohamed

A proposal has not yet been provided

$30 AUD in 3 dias
(0 Comentários)
0.0