Forum Discussion
Line graph of product price trends over time
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
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
Thanks Sergei! That's what I was after!!! :)