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