So I have data like such in the image. What I want the chart to do is, like a regular chart, use the 'Lot/Strain' as well as 'Grow Room#' column as the series, and the 'days flowering' as X-axis, and have the chart overlay these series on this x-axis. Purpose is to compare different conditions on plant growth over time on a sheet where I will be continually addind data, so I need it to group certain values as their own series. Currently it awkwardly divides each Lot into it's own section of the x axis and subdivides it.
Is there a way to do this in Pivot Tables or do I need to use another method?