Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding labels to a bubble chart other than the X, Y or Z values | Excel Discussion (Misc queries) | |||
Adding data labels to charts | Excel Discussion (Misc queries) | |||
labels for bubble charts | Charts and Charting in Excel | |||
how to edit all 10 bubble data labels at the same time | Excel Discussion (Misc queries) | |||
How do i add text labels to each bubble on bubble chart? | Charts and Charting in Excel |