title: Google Sheets x axis date and y axis multiple columns from data in one column in the source data
body: <p>I am trying to create a chart in Google Sheets that lists aggregated dates on the x axis and parts and related quantities on the y axis. The issue I am having is that the part source data is in one column. I need to know how I can get the y axis to display a column for each of the parts contained in the source column. I have attached an image that shows what I want vs what I am getting. The chart sums all parts together on a given date as opposed to breaking them down by part on a given date. How can I get the sheet to create an individual column for each part on a given date? Yellow is Part A and Red is Part B.</p>
  <p><a href="https://i.stack.imgur.com/Ygx54.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ygx54.png" alt="enter image description here" /></a></p>