Creating Complicated Graph

%3CLINGO-SUB%20id%3D%22lingo-sub-1335289%22%20slang%3D%22en-US%22%3ECreating%20Complicated%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335289%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20urgent%20question%20regarding%20excel%20-%20since%20it%E2%80%99s%20almost%20the%20end%20of%20the%20Friday%20(working%20week).%3C%2FP%3E%3CP%3EAs%20for%20the%20problem%20(please%2C%20see%20attached%20picture%20and%20excel%20file).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1rINWobnEObb83xixHhTI29DtaQRsYKSz%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdrive.google.com%2Fopen%3Fid%3D1rINWobnEObb83xixHhTI29DtaQRsYKSz%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShort%20Description%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20There%20is%20an%20360%20assessment%20of%203%20people.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Each%20worker%20has%20completed%20survey%3A%20what%20he%2Fshe%20thinks%20of%20oneself%2C%20what%20manager%20thinks%2C%20what%20colleges%20think%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20The%20scale%20is%201-5%20and%20it%20is%20very%20important%20to%20show%20the%20deviation%20of%20answers%20(if%20there%20is%20such).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4.%20Unfortunately%2C%20I%20don%E2%80%99t%20know%20how%20to%20show%20deviation%20in%20excel%2C%20so%20I%20formatted%20cells%20%E2%80%9Ctext%20typed%E2%80%9D%20to%20type%20in%20deviation%20(%E2%80%9C3-5%E2%80%9D%20for%20an%20example).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E5.%20The%20task%20is%20to%20graphically%20present%20answers%20(see%20table%20in%20excel)%20as%20it%20showed%20in%20the%20picture%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20my%20knowledge%20doesn%E2%80%99t%20provide%20me%20with%20enough%20expertise%20in%20excel%20to%20understand%2C%20how%20to%20perform%20it%2C%20as%20well%20as%20I%20haven%E2%80%99t%20yet%20found%20solutions%20in%20the%20internet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20why%2C%20I%20would%20really%20appreciate%20if%20you%20could%20help%20me%2Fteach%20me%2C%20how%20to%20solve%20this%20puzzle.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22360%20assessment.jpg%22%20style%3D%22width%3A%20749px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186449i24E0FD737498052D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22360%20assessment.jpg%22%20alt%3D%22360%20assessment.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%223360%20excel%20jpeg.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186448iE4D73834D5656D6B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%223360%20excel%20jpeg.jpg%22%20alt%3D%223360%20excel%20jpeg.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1335289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Dear community,

 

I have an urgent question regarding excel - since it’s almost the end of the Friday (working week).

As for the problem (please, see attached picture and excel file).

 

 

https://drive.google.com/open?id=1rINWobnEObb83xixHhTI29DtaQRsYKSz

 

Short Description:

 

 

 

1. There is an 360 assessment of 3 people.

 

2. Each worker has completed survey: what he/she thinks of oneself, what manager thinks, what colleges think etc.

 

3. The scale is 1-5 and it is very important to show the deviation of answers (if there is such).

 

4. Unfortunately, I don’t know how to show deviation in excel, so I formatted cells “text typed” to type in deviation (“3-5” for an example).

 

5. The task is to graphically present answers (see table in excel) as it showed in the picture attached.

 

 

 

Unfortunately, my knowledge doesn’t provide me with enough expertise in excel to understand, how to perform it, as well as I haven’t yet found solutions in the internet.

 

 

 

That is why, I would really appreciate if you could help me/teach me, how to solve this puzzle.

 

 

 

 

 

 

360 assessment.jpg3360 excel jpeg.jpg

0 Replies