I want to create a scatter chart but I am facing lots of difficulties. I have some age ranges of our customers (20-30,30-40,40-50 etc) and I want to see in a scatter chart, all of those purchases in terms of Price amount. For example, by the 1-1-2013, 1000 purchases have happened. I want to see 1000 dots in a chart, where every dot will have a color that represents the age range, the X-axis will be amount of purchase and the Y-axis will be the time.
This way, I want to see, which are the price gatherings in the different age ranges cross time.
I have done everything, please help me a little bit.
I have attached an example I have found that looks like the one I want to create.