Bubble Chart

[Ken1004]

Hi All,

I have created a set of bubble charts. The 'Z' value has positive and some negative values. When positive, the bubbles look fine. But when negative, the bubble disappears and no negative values are shown. How do I fix this? Thank you in advance.

 

[tomanton]

Hi

try changing vertical axis crosses to start at the lowest negative value

 

[Ken1004]

Hi

try changing vertical axis crosses to start at the lowest negative value

Thanks, but that did not work. Any other suggestions?

 

[tomanton]

it's hard to imagine the issue you're having, able to post the chart here?

i thought you had similar to this

 

[Ken1004]

it's hard to imagine the issue you're having, able to post the chart here?

i thought you had similar to this

https://www.dropbox.com/s/0i6631ab2m2bpn0/Image.png?dl=0

I couldn't add the image so I had to provide a link to dropbox. Please let me know if you can retrieve it. Thanks

 

[tomanton]

https://www.dropbox.com/s/0i6631ab2m2bpn0/Image.png?dl=0

I couldn't add the image so I had to provide a link to dropbox. Please let me know if you can retrieve it. Thanks

Can see the picture. The only thing I can think of would be to adjust X and y axis, to include the negative values

 

[Repush]

I would think that a negative bubble size is impossible
what data are you presenting?

 

[Gerald Higgins]

Maybe convert your negative values to positive, using the ABS function ?

 

[Ken1004]

I would think that a negative bubble size is impossible
what data are you presenting?

Hi, thanks for the responds. The data is real estate market. The market percentage can be up (positive) or down (be negative). I think I have to put in some conditions (not sure). After researching the web, bubble cannot be negative, but with conditions, we can go around that. Just don't know how to add the condition array. Thanks

 

[Gerald Higgins]

Maybe there's a better solution than a bubble chart ?