Display all values including repetitive Dimension values in a Scatter Plot?
I have a dataset as shown below:
Month Stock Price
2 A 21
2 B 33
2 A 46
2 C 54
2 D 59
2 C 63
2 E 72
I'd like to show these values on a Scatter plot: With Stock as the dimension, Month as the X-axis and Price(without any aggregation) as Y-axis. I've tried this but the Stocks A and C are not being shown in the plot. Is there any way to show A and C, twice in this instant with their different prices in the Scatter plot? If not please suggest a different but similar chart where I can show all the above points.
