Development of an interactive Excel chart using custom graph

Cerrado Publicado Aug 13, 2014 Pagado a la entrega
Cerrado Pagado a la entrega

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

Nº del proyecto: #6317039

Sobre el proyecto

13 propuestas Proyecto remoto Activo Sep 19, 2014

13 freelancers están ofertando un promedio de $196 por este trabajo

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 en 0 días
(328 comentarios)
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) Más

$138 AUD en 5 días
(95 comentarios)
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 Más

$450 AUD en 3 días
(25 comentarios)
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 Más

$79 AUD en 2 días
(65 comentarios)
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 en 3 días
(26 comentarios)
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 Más

$526 AUD en 3 días
(4 comentarios)
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 Más

$77 AUD en 3 días
(25 comentarios)
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 Más

$150 AUD en 3 días
(11 comentarios)
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 Más

$150 AUD en 3 días
(0 comentarios)
0.0
cindyzhou

A proposal has not yet been provided

$166 AUD en 1 día
(0 comentarios)
0.0