We help IT Professionals succeed at work.

Excel Bubble Chart

ubsmail
ubsmail asked
on
287 Views
Last Modified: 2012-05-11
Hello I cannot get the Y axis to move on the attached bubble cart. Can someone tell me why? Bad-bubble-Chart.xls
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
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 HusainEngineer
CERTIFIED EXPERT

Commented:
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
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.