Problem with axis for bubble chart

**rebeccagrace** · 10-31-2012, 12:47 AM

Hi,

To map business development pipeline I am trying to do the following with a bubble chart.

Verticle axis listing clients, horizontial axis a date range with bubbles differing in size relative to the expected dollar value of the client.

Can anyone help

Thanks

Rebecca

**Andy Pope** · 10-31-2012, 08:49 AM

You need to use fixed Y values for each client. To label the vertical value axis you can use a dummy series with X=0 and appropriate Y value.
Use data labels from that series, linked to cells to display client name

Free addin to link data labels to cells
http://www.appspro.com/Utilities/ChartLabeler.htm