Hi Mike -

I didn't mean to have you do it all manually, I was just explaining that you
can customize a data label, and Rob's tool lets you do it in bulk. It's one
of my favorite and most used add-ins.

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


"Mike M" wrote in
message ...

Thanks Jon,

I did try your method a and b, but with up to 50 alternate labels on
the chart, it was very time consuming - and I did have problems with
the labels not following the stacks if the chart scale changed as new
data was added, making even more manual adjusting.

I was Rob's chart labeler that I found and am now using - and that does
exactly what I was looking for. It replaces the auto generated value
label, which always follows the stack scale, with any text or number of
your choice, by looking an any cell rage specified.

I can now just copy and paste the data into the data sheet, and the
charts all auto generate, including my alternate values in all the
various stacks.

Mike


--
Mike M
------------------------------------------------------------------------
Mike M's Profile:
http://www.excelforum.com/member.php...fo&userid=2722
View this thread: http://www.excelforum.com/showthread...hreadid=493156