Development of an interactive Excel chart using custom graph

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

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

ID Проекту: #6317039

Про проект

13 заявок(-ки) Дистанційний проект Остання активність Sep 19, 2014

13 фрілансерів(-и) готові виконати цю роботу у середньому за $196

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 за 0 дні(-в)
(328 відгуків(и))
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) Більше

$138 AUD за 5 дні(-в)
(95 відгуків(и))
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 Більше

$450 AUD за 3 дні(-в)
(25 відгуків(и))
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 Більше

$79 AUD за 2 дні(-в)
(65 відгуків(и))
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 за 3 дні(-в)
(26 відгуків(и))
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 Більше

$526 AUD за 3 дні(-в)
(4 відгуків(и))
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 Більше

$77 AUD за 3 дні(-в)
(25 відгуків(и))
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 Більше

$150 AUD за 3 дні(-в)
(11 відгуків(и))
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 Більше

$150 AUD за 3 дні(-в)
(0 відгуків(и))
0.0
cindyzhou

A proposal has not yet been provided

$166 AUD за 1 день
(0 відгуків(и))
0.0