Creating Bubble Charts

[tina]

How do you create a bubble chart that displays the legend
as a description of the 3rd variable (the bubble size)?
For example, how would you create the following bubble
chart where the x-axis is column B, y-axis is column C,
bubble size is column D and legend is column A?

A1: B1:Gross Rev C1:Net Income D1:# of Plants
A2:East B2:830,000 C2:35,000 D2:26
A3:West B3:620,000 C3:54,000 D3:13
A4:North B4:150,000 C4:80,000 D4:40
A5:South B5:41,000 C5:15,000 D5:35

Any insight will be helpful!

 

[Frank Kabel]

Hi Tina
I would create a bubble chart and use one of the following tools for
labelling the bubble:
http://www.appspro.com/utilities/Labeler.asp
http://j-walk.com/ss/excel/files/charttools.htm

Frank