Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
bubble chart - how to edit all in one go
Hi ...
Have about 10 bubbles there. Need to format data labels of ALL 10 bubbles at the same time. (I wanna select Alignment label position center, that means moving all 10 data labels to the center of the bubbles) Any method that i can do it in one go, without the need to select and format it one by one ? Using Excel 2002. Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
bubble chart - how to edit all in one go
Hi,
If the bubbles are all different series then no. You can reduce the time by using F4 which will repeat the command. So format one data label and then select another and press F4. Cheers Andy wrote: Hi ... Have about 10 bubbles there. Need to format data labels of ALL 10 bubbles at the same time. (I wanna select Alignment label position center, that means moving all 10 data labels to the center of the bubbles) Any method that i can do it in one go, without the need to select and format it one by one ? Using Excel 2002. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i add text labels to each bubble on bubble chart? | Charts and Charting in Excel | |||
get edit mode on data lines in chart wizard | Charts and Charting in Excel | |||
customizing the mouse-over display 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) |