PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting bubble size display

Reply

bubble size display

 
Thread Tools Rate Thread
Old 02-07-2008, 12:07 PM   #1
hcacote@gmail.com
Guest
 
Posts: n/a
Default bubble size display


Dear All,

I am plotting some bubble charts in which the series are in the
following form:

ProductName, NumberParts,NumberVersions,TotalValue

The series are being plotted as NumberParts in X axis, NumberVersions
Y and TotalValue as the bubble size.

I would like to display in my graph the value of the bubble size. Is
there any way to do this ? From the different layouts available in
excel 2007 I just have the possibility to print the X,Y labels
(NumberParts , NumberVersions )


Thank you, Cheers,
Hugo
  Reply With Quote
Old 02-07-2008, 08:20 PM   #2
ShaneDevenshire
Guest
 
Posts: n/a
Default RE: bubble size display

Hi,

First try this. Double click the series on the chart and in the Format Data
Series box click the Data Labels tab and check whatever you want.

Alternatively go to http://www.appspro.com/Utilities/ChartLabeler.htm There
is a free download to add custom labels to charts.

--
Cheer,
Shane Devenshire


"hcacote@gmail.com" wrote:

> Dear All,
>
> I am plotting some bubble charts in which the series are in the
> following form:
>
> ProductName, NumberParts,NumberVersions,TotalValue
>
> The series are being plotted as NumberParts in X axis, NumberVersions
> Y and TotalValue as the bubble size.
>
> I would like to display in my graph the value of the bubble size. Is
> there any way to do this ? From the different layouts available in
> excel 2007 I just have the possibility to print the X,Y labels
> (NumberParts , NumberVersions )
>
>
> Thank you, Cheers,
> Hugo
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off