Completed

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

This project was successfully completed by dpune for $30 AUD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$10-$30 AUD
Completed In
3 days
Total Bids
3
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online