Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Formatting chart objects in Excel 97

Posted by Brad on March 11, 2001 4:08 PM

Hi,

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.

thx.

brad

Re: Formatting chart objects in Excel 97

Posted by Dave Hawley on March 11, 2001 9:55 PM

Hi Brad

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"

Dave
OzGrid Business Applications

Re: Formatting chart objects in Excel 97

Posted by Brad on March 13, 2001 7:26 PM

Hi,

I guess this will work in Excel 2000. I'm still stuck with Excel 97.

Thanks anyway.

brad

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.