3 variable data graph

Highlighted
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