Forum Discussion

careisin's avatar
careisin
New Member
7 years ago
Solved

bubble chart

I want to create a bubble chart like my mock up I slapped together in paint, where the x and y axis are categorical variables and the size of the bubble is the measurment like number of products sold.  It looks like I can't do this with a scatter chart because I can only use a categorical variable on one axis.  Is there another way around this? 

 

 

 

Need Help
  • MAQSupport's avatar
    MAQSupport
    7 years ago

    Hello careisin,

     

    Dot Plot by MAQ Software  supports categorical values on Axis category I and Axis category II.

     

    Please refer the below screenshots:

     

    This is the vertical orientation of the visual - 

     

    This is the horizontal orientation of the visual - 

     

     

    The orientations are configurable from the format pane.

     

    In the above example, categorical values have been inserted in Axis category I and Axis category II. Value field is used for the other axis. Bubble size is based on the numeric column inserted in 'Bubble size' field.

     

    'Value' field is optional. As per your use case, you can skip inserting column in 'Value' field.

     

    For any further queries or enhancement requests, please contact us at [email protected].

     

    Thanks.

6 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi careisin,

     

    By my tests, we only could show the categorical variable on x axis.

     

    You probably need to change to a different visualization or look at a custom visualization like Dot Plot by MAQ Software which may help you. 

     

    Best  Regards,

    Cherry

  • MAQSupport's avatar
    MAQSupport
    Solution Supplier
    7 years ago

    Hello careisin,

     

    Dot Plot by MAQ Software  supports categorical values on Axis category I and Axis category II.

     

    Please refer the below screenshots:

     

    This is the vertical orientation of the visual - 

     

    This is the horizontal orientation of the visual - 

     

     

    The orientations are configurable from the format pane.

     

    In the above example, categorical values have been inserted in Axis category I and Axis category II. Value field is used for the other axis. Bubble size is based on the numeric column inserted in 'Bubble size' field.

     

    'Value' field is optional. As per your use case, you can skip inserting column in 'Value' field.

     

    For any further queries or enhancement requests, please contact us at [email protected].

     

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello MAQSupport 

       

      Can you please send me the pictures attached to your answer because I can't see the example of vertical / horizontal orientation of the visual

       

      Thank you in advance!

      BR

       

      • MAQSupport's avatar
        MAQSupport
        Solution Supplier
        6 years ago

        Hello Anonymous ,

         

        Please find the attached screenshots for the Dot Plot by MAQ Software.

         

        Horizontal Orientation:


        Vertical Orientation:

         

         
         

        For any further queries or enhancement requests, please contact us at [email protected].

         

        Thanks

         

  • lcesarini's avatar
    lcesarini
    Frequent Visitor
    4 years ago

    Hi, I'm looking for several years a categorical X and Y  bubble chart.

    I've downladed and experimented with the solution proposed by Dot Plot by MAQ Software 

    I think it cannot be marked as solution to this topic since one of two axes seems to remain always numeric and do not represent Y category

    Axix Category II is represented  allways on the same axis (or on opposite side) , but never on Y axis.

    Orientation does not solve the issue.

    I would like to stress the importance o such king of graphic since it would help in finding relationships beewten dimensions otherwise difficult to discover.

     

    May be that with R (I do not know this language) it would be possible to obtain a chart like those show in topic question?