Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mrthomasshelby
Creator III
Creator III

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.

TIA.

12 Replies
mrthomasshelby
Creator III
Creator III
Author

This works for me as I can edit the script as needed. Thanks a lot Vinay!

OmarBenSalem

Great ! Thanks

mrthomasshelby
Creator III
Creator III
Author

Thanks Omar for taking the time. Appreciate it!