Forum Discussion

Deleted's avatar
Deleted
Nov 19, 2018
Solved

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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 19, 2018

    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

Deleted's avatar
Deleted
Nov 19, 2018

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 19, 2018

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

  • Deleted's avatar
    Deleted
    Nov 28, 2018

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

Resources