bubble chart

[careisin]

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? 

[lcesarini]

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?

[MAQSupport · Accepted solution]

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 support@maqsoftware.com.

Thanks.

[Anonymous]

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]

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 support@maqsoftware.com.

Thanks

[PeterDoerfler]

Unfortunately, that does not solve the original question:
The idea is to have one category on the x-axis, another category on the y-axis and to use a value only for the size of the bubbles.

Any suggestions?

[v-piga-msft]

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