ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Adding data labels to bubble charts (https://www.excelbanter.com/charts-charting-excel/249916-adding-data-labels-bubble-charts.html)

James

Adding data labels to bubble charts
 
Hi all

I have created a bubble chart using the following data:

Region Pax Net T'over PPP
WEU 2,767 2,208,782 507
NEU 726 855,592 296
EEU 733 787,839 315
BKN 743 719,743 299

Problem is if I create the report just using the data then it labels all of
the bubbles as "series 1". When I use all of the data including the column
and row headers for some reason it uses the first column as the name
(correct) but then the X values are rows B-D, the Y values are another row,
etc, etc, basically it's a mess! Is there anyway I can use just the data and
then attribute a label to each bubble?

Sorry for lack of detail but it's difficult to work out what on earth is
going on!


--
James.

James

Adding data labels to bubble charts
 
Not to worry all, trawling through the web I found a link to
http://appspro.com/Utilities/ChartLabeler.htm which seems to have answered
the question in case anyone is interested!

--
James.


"James" wrote:

Hi all

I have created a bubble chart using the following data:

Region Pax Net T'over PPP
WEU 2,767 2,208,782 507
NEU 726 855,592 296
EEU 733 787,839 315
BKN 743 719,743 299

Problem is if I create the report just using the data then it labels all of
the bubbles as "series 1". When I use all of the data including the column
and row headers for some reason it uses the first column as the name
(correct) but then the X values are rows B-D, the Y values are another row,
etc, etc, basically it's a mess! Is there anyway I can use just the data and
then attribute a label to each bubble?

Sorry for lack of detail but it's difficult to work out what on earth is
going on!


--
James.



All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com