In Progress

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

Skills: Excel

See more: 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

About the Employer:
( 32 reviews ) MALAGA, Australia

Project ID: #5086798

Awarded to:

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 More

$30 AUD in 3 days
(15 Reviews)
4.7

3 freelancers are bidding on average $22 for this job

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 More

$25 AUD in 1 day
(0 Reviews)
0.0
wikummapatuna

A proposal has not yet been provided

$10 AUD in 2 days
(0 Reviews)
0.0