Forum Discussion
Line graph of product price trends over time
Hi,
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:
| Date | Colour | Price |
| 07/02/2017 | Yellow | 11 |
| 07/02/2017 | Blue | 10.5 |
| 14/02/2017 | Red | 10 |
| 24/02/2017 | Red | 10.5 |
| 15/03/2017 | Blue | 10.5 |
| 04/05/2017 | Yellow | 12.5 |
| 19/05/2017 | Blue | 12.5 |
| 22/05/2017 | Blue | 12 |
| 05/06/2017 | Blue | 12.5 |
| 18/07/2017 | Blue | 12.5 |
| 03/10/2017 | Blue | 13 |
| 13/10/2017 | Yellow | 12.98 |
| 30/10/2017 | Blue | 12.5 |
| 30/11/2017 | Blue | 15 |
| 01/12/2017 | Blue | 13 |
| 12/12/2017 | Yellow | 13 |
| 14/12/2017 | Blue | 13 |
Hi Tim,
You may use the same approach but instead of zero return in helper columns #N/A error using NA() function. After that right click on your chart, Select data, left bottom button
and use such settings
4 Replies
Hi Tim,
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.
Hi Doug.
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.
Does that make sense?
Tim
Hi Tim,
You may use the same approach but instead of zero return in helper columns #N/A error using NA() function. After that right click on your chart, Select data, left bottom button
and use such settings
