Bubble Chart problems

[pangea17]

I created a bubble chart following the rule, x-axis, y-axis, bubble in regards to the order of columns. I get a bubble chart, but it is using the bubble numbers to for the Y-axis and the bubble size. Has anyone had this problem, or know how to solve it? Thanks.

 

[auto.pilot]

Possibly, right click on your chart, choose Select Data, then Switch Row/Column

 

[pangea17]

That just made things worse. But thanks for the effort.

 

[Steve=True]

I would suggest deleting your series, then going to select data and doing a new series where you can select the columns for your data.