Development of an interactive Excel chart using custom graph
$30-250 AUD
Оплачується при отриманні
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!
ID Проекту: #6317039
Про проект
13 фрілансерів(-и) готові виконати цю роботу у середньому за $196
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
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) Більше
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 Більше
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.
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 Більше
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 Більше