Avatar of ubsmail
ubsmail
 asked on

Excel Bubble Chart

Hello I cannot get the Y axis to move on the attached bubble cart. Can someone tell me why? Bad-bubble-Chart.xls
Microsoft Excel

Avatar of undefined
Last Comment
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Saqib Husain

Single click on any number on the Y-axis. This will select the Y-axis.
Press Ctrl-1  (one)

On excel 2003
Select the scale tab

On later versions
Select Axis options


Then change the minimum value to -10 or any other number that suits you.
Saqib Husain

Maybe you are right teylyn. I thought the question was to move the "Y-axis" as opposed to move the "Bubbles" along the y-axis

Saqib
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

ssaqibh, if you hover the mouse over an individual bubble and look at its values in the popup, you'll see that the Y value is 0 for each bubble. That's because the Y values are sourced from text, and text = 0 for chart data point values. After the text-to-column conversion, the bubble center will be at the correct position for the respective value in column C.

I assume that the source data for the chart may have been copied and pasted from somewhere and not all columns were interpreted as numbers.

cheers, teylyn
Your help has saved me hundreds of hours of internet surfing.
fblack61