Forum Discussion

Qianru221's avatar
Qianru221
Icon for Helper II rankHelper II
8 years ago
Solved

scatter plot with date on the x-axis

Hi all,

 

I plotted a graph of price versus date to show price changes across time using line chart. However I would like to only show the price as single dots i.e. to remove the lines connecting them. How would I be able to achieve that?

 

I have tried with scatter chart, but the date on the axis is counted. Therefore the result is now what I have expected. Anybody have an idea on how to present the price versus date in a scatter plot form?

 

Thank you.

 

Need Help
  • san_jois's avatar
    san_jois
    8 years ago

    Hi,

    I tried using a dummy data..

    Keep the Date hierarcy selected..

    Under X-Axis, Concatenate-Off (toggle)

    Hope it works

6 Replies

  • san_jois's avatar
    san_jois
    Icon for Resolver I rankResolver I
    8 years ago

    Hi,

    Go to formatinng of the line chart

    Under options, find X-Axis

    Then Select the Type as Categorical

    Scroll below to find Show marker and move the toggle to 'on' position

    Increase the size of the bubble..you can choose the shape of the marker as well as the size and colour

    Scroll up to see Data colours and choose the data colour as white..(Pls keep the background same as white, else select the data colour same as the background)

    Thats it..

    Hope it helps

     

     

    • Qianru221's avatar
      Qianru221
      Icon for Helper II rankHelper II
      8 years ago

      Hi

       

      Many thanks for the help! It works.

      However initially the x-axis is set as per month (since there are many price points per month and I averaged for each month, so for each month there is only one price point). After adjusting the x axis to categorical, every single price point shows up...so the x axis is extremely long now....

      • san_jois's avatar
        san_jois
        Icon for Resolver I rankResolver I
        8 years ago

        Hi,

        I am not sure if you have prepared a different sequential date table and connected your date from data with that. This helps because you can then use this date from sequential date table in all your plots.

         

        Based on the level of drill down, the date table will have categories displayed on X axis

         

        It would start with a year then move to Quarter-Month-Week and Day

         

        Automatically, your data, which may be daily will get summed or averaged (based on the measure you choose during plotting)

         

        On the other hand, if you have already connected, then just drilling up should solve your issue