Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dot Plot with Fixed Y-Axis

I am trying to create a Dot Plot that has a fixed Y-Axis that will allow me show the full range of possible Y-Values even if there isn't a data point that is plotted against that Y-value.

 

I would like to show all of the categories along the Y-Axis (fromm Unaware to Buy In) even if the category is empty and there isn't a data point that falls into that category. For example, if there wasn't a data point plotted at (3, Acceptance) I would still want the Acceptance category to be shown in order on the Y-Axis. How can I do this? 

 

 

 
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may tick the option "Show items with no data" .

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

    Select to include null values.  And/or set the min and max values for that axis manually.

    HTH

    Michele

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous 

      Few more details. In the Formatting pane, play around with these settings.  Also try switching between Linear and Log.

      HTH

      Michele

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thanks for your response. I have looked into the Axis settings but haven't been able to find anything...

         

        The "Commitment Level" field in Category I is populating my Y-Axis but is only showing the categories that contain data (Unaware-1, Aware-2, Understanding-3, Buy In-5) and not showing Acceptance-4 because there are no data entries in the category. How do I solve for this?

         

             

         

         

         

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    You may tick the option "Show items with no data" .

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.