Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
PearlBeast
 
Posts: n/a
Default How can I change the position/format for all data labels in a ser.


  #2   Report Post  
Andy Pope
 
Posts: n/a
Default

Hi,

Double click a data label. The format dialog should then allow you to
format the labels, its font attributes and alignment.

Cheers
Andy

PearlBeast wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Rob Bovey's Chart Labeler also has a feature to Move all labels for a series en
masse. It's a free download, easy to install and use:

http://appspro.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Andy Pope wrote:

Hi,

Double click a data label. The format dialog should then allow you to
format the labels, its font attributes and alignment.

Cheers
Andy

PearlBeast wrote:


  #4   Report Post  
John Mansfield
 
Posts: n/a
Default

Another option via code . . .

Sub MoveLabels()

Application.ScreenUpdating = False

On Error Resume Next

Dim A As Integer 'Start Value
Dim B As Integer 'End Value
Dim C As Integer 'Increment Value
Dim D As Integer 'Vertical Move
Dim E As Integer 'Horizontal Move
Dim F As Integer
Dim G As Integer

Set Cht = ActiveChart

Set Srs1 = ActiveChart.SeriesCollection(1)

Set Pts1 = Srs1.Points

A = 1 ' Start Value
B = 6 ' End value
C = 1 ' Increment Value
D = 10 ' Vertical Move
E = 10 ' Horizontal Move

Do Until A B

'Sets the label font size
Srs1.Points(A).DataLabel.Font.Size = 10
'Sets the label number format
Srs1.Points(A).DataLabel.NumberFormat = "#,##0"

F = Srs1.Points(A).DataLabel.Top
Srs1.Points(A).DataLabel.Top = F + D

G = Srs1.Points(A).DataLabel.Left
Srs1.Points(A).DataLabel.Left = G + E

A = A + C

Loop

End Sub


"Jon Peltier" wrote:

Rob Bovey's Chart Labeler also has a feature to Move all labels for a series en
masse. It's a free download, easy to install and use:

http://appspro.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Andy Pope wrote:

Hi,

Double click a data label. The format dialog should then allow you to
format the labels, its font attributes and alignment.

Cheers
Andy

PearlBeast wrote:



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas in source data Ken Charts and Charting in Excel 3 December 1st 04 06:43 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"