Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wanted to create a chart to show price changes over the time.
I used scatter chart. In the simple case, as shown in my first example below: point to point
I have an article, in early2015 it was $ 60, after the first change, it becomes 50 in late March, and down to 40 at the end of 2015.
But in somes cases complex, I can observe different prices for the same date as shown in my another example: point to multipoints
So how can I do? anyone have idea about it.
Thanks
Hi,
Can you post some sample data? It seems like you should be able to do it with a scatter chart.
Thanks
Why don't you use CandleStick chart, which is the appropriate visualization for your kind of data?
Hi,
below some sample data.
Case simple
LOAD * INLINE [
Date, Article, Price, nb change
31/01/2015, A1, 59.9, 1
31/03/2015, A1, 49.9, 2
31/12/2015, A1, 34.9, 3
];
Case complexe
LOAD * INLINE [
Date, Article, Price, nb change
31/01/2015, A1, 59.9, 1
31/03/2015, A1, 49.9, 2
31/12/2015, A1, 34.9, 3
31/12/2015, A1, 54.9, 3
];
What if you concatenate these two tables and then pull all the distinct values? As a result of this, you will have a cleaner data model to work with:
What do you think?
we have a lots of articles, i don't know werthere CandleStick chart is appropriate for us.
Do you have un sample about CandleStick chart
How can you show these datas in scatter chart?
Yeah, showing the dates is not pretty:
Thanks sinan,
But i want to show data in scratte chart non bulles chart.