Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Chart datalabels (Excel xp)

    I have a chart, see the attached excel file. I would like to put 2 labels in each chart and the only way i can think of doing it is with a text box. I did one for the bottom bar 1.

    I would like to put both labels in each section of the bar thru programming because i will have about 30 of them and don't want to put in text boxes. Also, the numbers will change and i will have to change the spacing between each number in the text box (ick). Is there any way to do what i want? thanks for the help.
    Attached Files Attached Files

  2. #2
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Chart datalabels (Excel xp)

    An Excel Add-in I wrote might be of assistance to you.
    You can type label titles in adjacent cells on a spreadsheet, format the cells
    and then create and add labels automatically to your chart.

    I have attached the Word.doc instruction sheet for the add-in (50kb).
    It it looks of interest, let me know and I will e-mail the add-in (160kb).

    Jim Cone
    San Jose, CA

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Chart datalabels (Excel xp)

    You can make "data labels' with 2 lines of text. In I1 enter something like:
    =TEXT(A1,"0.0")&CHAR(10)&TEXT(E1,"0.0")
    Copy this thru I1 - K3.The Char(10) adds an "internal" cell carriage return.
    To enter as "datalabels" select the label until only 1 is selected (it will have a box around it) and then in the formula bar enter = and the cell for reference
    Or if you want a macro you can use loop through all the data labels using something like:

    activechart.SeriesCollection(1).points(1).datalabe l.text = range("i1:k3").cells(1,1).Value

    to assign the labels automatically.
    The seriescollection refers to each of the chart series
    The points are the individual values of that series
    Cells refer to each of the cells in the range, 1st number is row, 2nd is column).

    Steve

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Chart datalabels (Excel xp)

    yes, this would help me greatly. thank you very much for the add-in.

  5. #5
    New Lounger
    Join Date
    Mar 2001
    Location
    Gauteng, South Africa
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart datalabels (Excel xp)

    I'd appreciate it if I can make use of it as well (in Excel 97). I've also used Rob Bovey's XY Chart Labeler (http://www.appspro.com/utilities/Labeler.asp), but I changed to an NT machine some time ago and I need admin rights (which I don't have!) to install his programme now.

  6. #6
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Chart datalabels (Excel xp)

    To All,

    Apparently there is no way to send e-mails thru the lounge with an attachment.
    For those wanting a copy of the Excel Add-in "Chart Data Labels",
    please e-mail me at the following address:
    jim_cone@NOSPAMatt.net (remove the 'nospam').
    I've also attached a slightly revised copy of the Word.doc instructions for new readers of
    this post.

    Jim Cone
    San Jose, CA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •