Thread: Bubble Charts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Bubble Charts

If you have a single series, you can double click on it and on the Options
tab, choose Vary Colors by Point. Otherwise, you can select individual
points (single click to select the series, another single click to select
the point, then double click to format each with a different color). To
apply custom labels to the points, you could apply default labels and edit
the text of each (again, two single clicks to select the individual label,
then edit its text), or you can use one of these free utilities to use a
separate worksheet range for the labels:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jenna" wrote in message
...
Hi,

I have created a bubble chart in excel. I would like the individual
bubbles
to have different colours and also for them to have labels that are
different
to the data used to size them (ie they are sized on size of customer,
however, I would like the name of the customer to show next to the bubble)