I'm wanting to create a line chart that shows the number of sales for each product by month. When I set up the chart, I keep getting this jumbled chart, below. I tried moving the Dates to the Rows and the Brands to the columns but it doesn't fill out right, either. Any recommendations on how to solve this?
Thank you,
Below is when I move one date to the rows.
Thank you,
Below is when I move one date to the rows.