3 variable data graph

%3CLINGO-SUB%20id%3D%22lingo-sub-1549712%22%20slang%3D%22en-US%22%3E3%20variable%20data%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1549712%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%20so%20i%20tried%20to%20research%20this%20online%20and%20found%20no%20solution%20to%20my%20specific%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20gathered%20some%20data%20on%20the%20following%3A%20we%20have%203%20types%20of%20machines%20at%20our%20firm%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esmall%20medium%20and%20large.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20an%20excel%20file%20with%20each%20order%20containing%20names%2C%20quantity%2C%20machine%20type%20(s%2Cm%2Cl)%20and%20the%20weeks%20they%20are%20being%20produced%20(1-53)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Enow%20i%20would%20like%20a%20chart%20where%20on%20the%20x-axis%20i%20see%20the%20weeks%20and%20per%20week%203%20bars%20(s%2Cm%2Cl)%20that%20show%20the%20added%20up%20quantites%20on%20the%20y-axis%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20because%20there%20can%20be%20more%20than%20one%20data%20input%20on%20the%20(eg)%20small%20machine%20in%20week%2035%2C%20so%20these%20need%20to%20be%20added.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20attached%20the%20file%20i'm%20working%20with%2C%20without%20cutomer%20names%20and%20such%2C%20just%20the%20data%20that%20needs%20to%20be%20worked%20with%20in%20the%20graphe%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20also%20attached%20an%20example%20of%20what%20i%20could%20like%20it%20to%20look%20like%2C%20just%20so%20you%20have%20an%20idea%20of%20what%20i%20mean%20(%20a%20picture%20says%20more%20that%20a%201000%20words%20right%3F!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20don't%20just%20make%20the%20graph%2C%20i%20really%20need%20to%20know%20how%20to%20do%20this%2C%20also%20this%20work%20list%20changes%20and%20i%20want%20to%20be%20able%20to%20add%20data%20aswell%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1549712%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E3%20variables%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGraph%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

hi, so i tried to research this online and found no solution to my specific problem.

 

i have gathered some data on the following: we have 3 types of machines at our firm:

 

small medium and large.

 

i have an excel file with each order containing names, quantity, machine type (s,m,l) and the weeks they are being produced (1-53)

 

now i would like a chart where on the x-axis i see the weeks and per week 3 bars (s,m,l) that show the added up quantites on the y-axis

 

this because there can be more than one data input on the (eg) small machine in week 35, so these need to be added.

 

i attached the file i'm working with, without cutomer names and such, just the data that needs to be worked with in the graphe,

 

i also attached an example of what i could like it to look like, just so you have an idea of what i mean ( a picture says more that a 1000 words right?!)

 

please don't just make the graph, i really need to know how to do this, also this work list changes and i want to be able to add data aswell

 

 

0 Replies