Help with creating bar graph from dashboard

[KrystaMarie]

Hi,


Firstly I am sorry if i make no sense! I am out of my league here.

If you feel you can help me i can send my form in excel to your email to discuss further.


I am creating a reporting dashboard so we can track audits done on the projects in the company. There are 8 categories called GMRs with 7 - 15 inner categories in each giving a total of 86. So not all are equal.


There are 26 projects.

I need to create a spreadsheet that allows staff to run a compliance report on any individual project or ALL together to see their compliance against the GMRs.


I want it to be a bar graph.


This is a snap shot of the data.

[pre]

Data		C = COMPLIES		NC = Non-Compliant		N/A = Not Applicable				

No.	GMR's	SCUPH	QUT	W'Gabba	ELF    River  Buli	Aviation
1 	1
1	1.1	C	NC	C	C	C	C	C	C	C
2 	1.2	NC	C	NC	NC	NC	NC	NC	NC	NC
3 	1.3	N/A	C	N/A	N/A	N/A	N/A	N/A	N/A	N/A
4 	1.4	NC	NC	NC	NC	NC	NC	NC	NC	NC
5 	1.5	C	C	C	NC	C	C	C	C	NC
6 	1.6	C	C	C	C	NC	C	C	C	C
7 	1.7	NC	NC	NC	C	C	NC	NC	NC	C
8 	1.8	C	N/A	C	NC	C	C	C	C	NC
9 	1.9	NC	NC	NC	NC	NC	NC	NC	NC	NC
10 	1.10	N/A	C	N/A	N/A	N/A	N/A	N/A	N/A	N/A
11 	1.11	NC	C	NC	NC	NC	NC	NC	NC	NC
12 	1.12	C	NC	C	C	C	C	C	C	C
13 	1.13	C	C	C	C	C	C	C	C	C
14 	1.14	NC	N/A	NC	NC	NC	NC	NC	NC	NC
15 	1.15	C	NC	C	C	C	C	C	C	C
16 	2
17 	2.1	N/A	C	N/A	N/A	N/A	N/A	N/A	N/A	N/A
18 	2.2	NC	NC	NC	NC	NC	NC	NC	NC	NC
19 	2.3	C	C	C	C	C	C	C	C	C
20 	2.4	C	N/A	C	C	C	C	C	C	C
21 	2.5	NC	NC	NC	NC	NC	NC	NC	NC	NC
22 	2.6	C	C	C	C	C	C	C	C	C
23 	2.7	NC	C	NC	NC	NC	NC	NC	NC	NC
24 	2.8	N/A	NC	N/A	N/A	N/A	N/A	N/A	N/A	N/A
25 	2.9	NC	C	NC	NC	NC	NC	NC	NC	NC
So far to run an overall bar graph to cover all projects this is what i have done

Current	Goal
GMR1	181	390
GMR 2	81	234
GMR 3	130	260
GMR 4	107	260
GMR 5	108	312
GMR 6	79	182
GMR 7	81	208
GMR 8	80	208

[/pre]
Although this doesnt get an easily trackable bar graph as they are at all different levels. I need to do a weighting formula? (sorry i dont know the terms) to make the GOAL to sit evenly at 100% across the page so we can see where each GMR is sitting.


But because the goals are so different i dont know how to work out how they are to be 100%

 

[bobhc]

Good day KrystaMarie


Welcome to the forum


Urgent to you means nothing to forum members, you must realise that this board is 24/7 and members have their own lives to live. I have removed Excel and help from the tags as they are meaningless to a form that gives help to excel users please read the following link, and be patience you will get help.


Title edited


http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting


and this link tell you how to upload sample workbooks by using such sites as Dropbox


http://chandoo.org/forums/topic/posting-a-sample-workbook


post edited with back ticks