Share via

Bubble Chart Does Not Recognize X Values

triptotokyo-5840 36,686 Reputation points Volunteer Moderator
2010-02-13T09:59:02+00:00

I have posted my Workbook at:-

http://www.pierrefondes.com/

It is item number 60 towards the top of my home page (go to Chart tab of my Workbook).

This example is pulled directly from MS documentation.

If I compare my chart to Microsoft's all of the bubbles on my chart are bunched up to the left.

They should be where MS documentation shows them: between about 12 on the X axis and between about 23 on the same axis (reflecting cells A2 to A5 of the underlying data).

I have noticed that changing the values in A2 to A5 makes no changes to the chart.

What am I doing wrong here?

TIA for any replies.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

triptotokyo-5840 36,686 Reputation points Volunteer Moderator
2010-02-13T10:34:04+00:00

OK, got it sussed. MS say:-

It is best not to include row or column headings in the selection. If you select the headings with your data, the chart may produce incorrect results

I therefore excluded A 1 to C 1 from the underlying data and the bubbles duly moved over to the right hand side.

This item is therefore closed.

Apologies for posting.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest