Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007Back to Charting for Excel archive index
When drawing BAR charts I often want to have the data values show up. However, if I want to change their position, I have to do so individually. Is there any way to group them so that they can be moved around together, like we do in Word and Powerpoint.
Other than copying or dragging the chart into Word or Powerpoint the best I think you will do is:
Single click Any data label and then right click and select "Format data labels" then "Alignment" and use the "Change label position"
OzGrid Business Applications
I guess this will work in Excel 2000. I'm still stuck with Excel 97.