JWalk Chart Tools series label problem

[Jamie Martin]

I am using John Walkenbach's "JWalk Chart Tools" add-in to label a data
series with values from other cells. (I want percentages as data labels even
though the series is charted as actual values.) The two cells I'm using to
label the two points in my series are not next to each other, if this is
important. I CTRL-click the two cells and they are listed in the selection
window with a comma, like this: 'Source data'!$D$8, 'Source data'!$AG$8 .
This looks good to me. But while the values in D8 and AG8 are 5.33% and
5.16%, the labels show up as 5.33% and 21.93%

Bizarre, huh? I thought for a second that 21.93 might be the PRODUCT of 5.33
and 5.16, but that product is closer to 28. Can anyone help?

What I'd really like to do, while I'm at it, is to show BOTH the actual
values and the percentages in a two-part data label. (At the moment, the
actual values can only be estimated from the labels on the Y-axis.) If
anyone can do that, I will be deeply impressed.

Thank you very much,

Jamie

 

[John Walkenbach]

Jamie, the labels range needs to be in a contiguous range.

You can use a formula to combine two or more values in a single cell.
Something like this:

=A1 & ", " & B1

This shows the value in A1 and B1, separated by a comma. Do that for each
data point, and make sure that these formulas are in a contiguous range.
Then the Chart Tools utility should work.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

 

[Jamie Martin]

OK, I see what JWalk is doing: it uses the first label I specify and then
just reads down one row to get the next label, ignoring the second cell
address I specified. Is there anything I can do about this?

 

[Jamie Martin]

That's sweet. I'd really like to have each value on its own line. Is there a
return character, such as =A1 & "/n" & B1 ?

 

[John Walkenbach]

Use CHAR(10) to force a new line.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

 

[Dave Peterson]

=text(f15,"0.00%") & char(10) & "(" & e15 & ")"

(It should look ok in the cell--untested in the chart.)

And set that cell to wordwrap (format|cells|alignment tab).