If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
Edit an organisation chart without re-formatting into VBA color-f. | 124kerryw | General Discussion | 1 | January 5th, 2005 10:17 PM |
I need to combine a bubble chart and a line graph (Excel 2003) | Rippbird | Charts and Charting | 1 | November 5th, 2004 12:23 AM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
Legend Bubble Chart | Pep | Charts and Charting | 1 | May 15th, 2004 12:43 AM |