12 Replies Latest reply: Apr 26, 2017 5:39 AM by Phalgun Parvathaneni RSS

    Display all values including repetitive Dimension values in a Scatter Plot?

    Phalgun Parvathaneni

      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.