Development of an interactive Excel chart using custom graph

Closed Posted Aug 13, 2014 Paid on delivery
Closed Paid on delivery

I have a customised graphic that I want to be able to use as a custom chart in Excel (see attached) which, depending on the value entered for each variable will change its colour. This will be based on a traffic-light scheme where Red = Low, Orange = Medium, Green = High. An example of this can be seen in the attached spreadsheet.

There are 3 areas involved which are:

READINESS (total of 30 points).

This consists of five elements:

1. Leadership Support,

2. Need for Change,

3. WIIFM,

4. Change Process, and

5. Confidence

Each of these elements can score a maximum of 6 points

Scoring/Traffic Light Colour

0 - 1.99 scores Low (Red)

2 - 3.99 scores Medium (Orange)

4 - 6 scores High (Green)

CAPABILITY (total of 40 points).

This consists of two elements:

1. Personal Capability and

2. Organizational Capability

Each of these elements can score a maximum of 20 points

0 – 7.99 scores Low (Red)

8 – 13.99 scores Medium (Orange)

14 - 20 scores High (Green)

BELIEFS (total of 30 points).

This consists of three elements:

1. Significant Others

2. Attitude

3. Perceived Difficulty

Each of these elements can score a maximum of 10 points

0 – 3.99 scores Low (Red)

4 – 7.49 scores Medium (Orange)

7.5 – 10 scores High (Green)

Note: I would also like to change the scoring values, if I want to, for which the different colours apply. For example, in Beliefs, if I want to change Low to being from 0 - 5.49, Medium to 5.5 - 7.99 and High from 8 - 10.

I look forward to hearing from you!

Excel Powerpoint

Project ID: #6317039

About the project

13 proposals Remote project Active Sep 19, 2014

13 freelancers are bidding on average $196 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$250 AUD in 0 days
(328 Reviews)
7.6
shikhamehta

Hey, I reviewed the spreadsheet that you shared. If I understand this correctly, the individual slices of the doughnut chart will always be on same size (since otherwise the chart may not look balanced as it s now) More

$138 AUD in 5 days
(95 Reviews)
6.3
samitXI

https://www.freelancer.com/jobs/Mathematics/l-en/1/Hi Sir, I am ready to work for you.I have 9 years of experience in C/C++, python , java, PHP and, MySQL. please see some of my works also check my reviews you will ge More

$450 AUD in 3 days
(25 Reviews)
5.0
ethicalboy

Hello, for creating something like your doughnut charts potentially there are two solutions, one is using some conditions in excel and another one is using macros, let me know if you have mac or windows. If you like w More

$79 AUD in 2 days
(65 Reviews)
5.2
Mufaddalsaifee

Kindly allocate this project to me and i have many ideas related to the above functionality and if i got this project i will assure you that i will complete it on time and with quality work.

$155 AUD in 3 days
(26 Reviews)
4.5
fattahaabdul

i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very good communication skills More

$526 AUD in 3 days
(4 Reviews)
3.6
sayli2

I can develop this custom chart very easily Expertise: I have more then 7 years of industry experience of software/web/database development with 4 years of computer science educational background with Microso More

$77 AUD in 3 days
(25 Reviews)
3.6
ygpravikumar

Hi, You want the pie chart to change its color based on the values entered right. I can achieve this 2 days, but for quality purposes like to incorporate any changes, suggestions iam quoting 3 days. Please cont More

$150 AUD in 3 days
(11 Reviews)
3.3
selfbiz

I can call myself a pro in EXCEL work and worked on several projects professionally. The problem you have mentioned here can be sorted out using INBUILT MS EXCEL FEATURES (I am aware of it). I can discuss with you, if More

$150 AUD in 3 days
(0 Reviews)
0.0
cindyzhou

A proposal has not yet been provided

$166 AUD in 1 day
(0 Reviews)
0.0