What I need to analyse is evolution of prices in time. For each item its done. I made the graph.
For the companies, the P.S. 2 is perfect if possible. I need to know time. But I don't know how to make excel understand the company as color, the item as dot, the X as time and Y as price.
The data doesn't need to be aggregated. As you have each dot as a new quote floating in the chat according to time and price.
I made a new one. This one is better because it have more companies for each item, more realistic: Data v3.xlsx
Bookmarks