SOLVED
Home

Line graph of product price trends over time

Deleted
Not applicable

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:

 

DateColourPrice
07/02/2017Yellow11
07/02/2017Blue10.5
14/02/2017Red10
24/02/2017Red10.5
15/03/2017Blue10.5
04/05/2017Yellow12.5
19/05/2017Blue12.5
22/05/2017Blue12
05/06/2017Blue12.5
18/07/2017Blue12.5
03/10/2017Blue13
13/10/2017Yellow12.98
30/10/2017Blue12.5
30/11/2017Blue15
01/12/2017Blue13
12/12/2017Yellow13
14/12/2017Blue13
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.

 

Price over time.JPG

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

Solution

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

image.png

and use such settings

image.png

Thanks Sergei!  That's what I was after!!! :)