Em Andamento

Excel - Insert Dynamic Graph that updates based on Data keyed on other Tabs

QUICK AND EASY ONE FOR YOU EXCEL GURUS OUT THERE

IN THE ATTACHED FILE THERE ARE 7 TABS

THE FIRST TAB IS TITLED INSTRUCTION SHEET - I WOULD LIKE A BAR GRAPH INSERTED ON THIS TAB NICE AND BIG IN 3D AND IN COLOR

THE X AXIS IS BE TITLED COMPLAINT TYPE AND IS TO HAVE A SECTION DEDICATED TO EACH TAB IN THE WORKSHEET ( WAREHOUSE ISSUES, SUPPLY NON CONFORMANCE, CUSTOMER COMPLAINT ETC.) AND THE BAR TO BE COLORED THE SAME COLOR AS ITS CORRESPONDING TAB COLOR

THE Y AXIS IS TO BE TITLED NUMBER OF OPEN COMPLAINTS NUMBERED FROM 1 TO 10

IF IN EITHER OF THE TABS A CELL IS POPULATED IN COLUMN D (DATE RAISED) WITH ANYTHING (SHOULD ALWAYS BE A DATE) AND THE F COLUMN F (DATE CLOSED) IS BLANK THEN THE CORRESPONDING BAR ON THE GRAPH ON THE INSTRUCTION SHEET TAB IS TO COUNT THIS AS ONE AND UPDATE THE GRAPH ACCORDINGLY - IF THERE IS DATA IN BOTH COLUMN D AND F THEN THE GRAPH IGNORES THIS AND DOES NOT COUNT IT

SO FOR EXAMPLE IF IN THE YELLOW CUSTOMER COMPLAINT TAB THERE ARE 10 RECORDS AND ALL OF THEM HAVE A DATE IN COLUMN D HOWEVER ONLY 3 OF THEM HAVE THE COLUMN F BLANK THEN THE YELLOW BAR ON THE GRAPH SHOULD READ 3

Habilidades: Excel

Ver mais: graph updates tabs, x-axis, the graph, one tabs, graph this data, graph of data, graph data type, graph c, first graph, excel gurus, data on a graph, data in a graph, c graph, as graph, 10 gurus, customer data in excel, 3d warehouse, insert date, count number tabs, excel count, excel column update, dynamic 2013, excel color cell, read excel file sheet, tab count

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

ID do Projeto: #5086798

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

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

3 freelancers estão ofertando em média $22 para este trabalho

wikummapatuna

A proposal has not yet been provided

$10 AUD in 2 dias
(0 Comentários)
0.0
m8880

Hi, I am a new freelancer and I don't have any recommendations so far but I already have experience in various field of categories such as writing, design, translations and data entry. To be more precise with the sta Mais

$25 AUD em 1 dia
(0 Comentários)
0.0