Completed

EXCEL - DYNAMIC BAR GRAPH - repost 2

This project was successfully completed by dpune for $45 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
2
Project Description

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

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