Chart datalabels (Excel xp)

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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).datalabel.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

Reply | Quote

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

Reply | Quote