I want to produce a line graph showing price trends over time. I want a line per product variant. But my data looks like this and I can't get it to present correctly. Could someone give me some tips/guidance:
You could try to re-structure the data and make the colors columns. I added some sparklines below and a line chart to the right. You might try to summarize the time into like Month where for each time period, each color has a value so there aren't zeros.
Thanks for that. I've tried that, but I'm trying to get the lines to link up the actual price points, so not go down to 0 where there was no sale. Equally I don't want it to show the price remaining at the previous price where there was no sale. So if the there is a sale on 1st November and another on the 5th of November the line should be a straight line between the two.