Try this link

http://office.microsoft.com/en-us/as...170761033.aspx

"Mark" wrote:

I want to create a bubble chart, however when I select the data it doesn't
recognise the format. Below is the table I use...Three customers (the data
points) with each three values (X, Y, size). If I select this, the charts
selects whole columns as X and Y value. How should I create this table to
have it working correctly?

Customer 1 Customer 2 Customer 3
Customer risk 25 100 150
Customer potential 10 60 150
Gross Sales Proceeds 100 150 50