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.
Re: Display all values including repetitive Dimension values in a Scatter Plot?
Hello omar bensalem,
Thanks for the reply. But you see I don't want to Sum the Prices. I want to display each and every point in the dataset above. That is I need A to be shown as two points: One point with price 21 and other with 46. Similarly, C should be displayed twice: one point with price 54 and the other with price 63. Is there a way to do so? TIA.