Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble chart: data label options
Hi all
Excel 2007 I have a worksheet from which I am trying to generate a bubble chart (XY). For the sake of argument let's say the worksheet has the following columns and row values: Project ID, Priority, Duration 1, 5, 12 2, 3, 20 3, 8, 8 When creating the chart, I can generate the bubbles where Priority and Duration (X and Y) intersect (which is great). I can also make the bubble size equal to Priority (also great). What I can't seem to be able to do is set the data label to the value of of "Project ID", as this is not one of the available options (which appear to be limited to X, Y, Series or Bubble Size). Is there any way to do this? The only workaround I've come up with so far is to create a new series for each row of the worksheet and then to select Series as the value for the bubble data label. Seems very inefficient to do it this way. Tony Directory Services MVP and Excel Muppet |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble chart: data label options
"Tony Murray" wrote:
Hi all Excel 2007 I have a worksheet from which I am trying to generate a bubble chart (XY). For the sake of argument let's say the worksheet has the following columns and row values: Project ID, Priority, Duration 1, 5, 12 2, 3, 20 3, 8, 8 When creating the chart, I can generate the bubbles where Priority and Duration (X and Y) intersect (which is great). I can also make the bubble size equal to Priority (also great). What I can't seem to be able to do is set the data label to the value of of "Project ID", as this is not one of the available options (which appear to be limited to X, Y, Series or Bubble Size). Is there any way to do this? The only workaround I've come up with so far is to create a new series for each row of the worksheet and then to select Series as the value for the bubble data label. Seems very inefficient to do it this way. Tony Directory Services MVP and Excel Muppet _______________________ Found a very useful chart labeler tool he http://www.appspro.com/Utilities/ChartLabeler.htm Worked like a charm with my chart in Excel 2007. Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change the color of negative bubble in bubble chart | Charts and Charting in Excel | |||
How can I change the color of negative bubble in bubble chart | Charts and Charting in Excel | |||
How do I add a unique data label to each point in a bubble chart? | Charts and Charting in Excel | |||
ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel | |||
How do I move a hidden bubble to the front in a bubble chart in E. | Excel Discussion (Misc queries) |