Monitoring complaints, each month complaints are put into a spreadsheet that show the types of complaint and puts them into a bar graph. I am trying to put these monthly sheets into an annual graph to show trends. I have managed to get the number of complaints to transfer into the annual chart but it doesn't differentiate between types of complaint in the final chart. How can I get the secondary information, not just the number of complaints but the colour coded type of complaints to display too? Attached are photos explaining my issue. Thank you in advance.
Solved by X. D. in 25 mins