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

IN PROGRESS
Bids
3
Avg Bid (AUD)
$22
Project Budget (AUD)
$10 - $30

Project Description:
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 required:
Excel
Qualifications required:
us_eng_1 US English - Level 1
Additional Files: BIF_LOG.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 3 days
Hire m8880
$ 25
in 1 days
Hire wikummapatuna
$ 10
in 2 days