I have a stacked bar chart, with the stacks representing total hours of
various groupings of personal.

I would like to add data to the chart, but here is the problem. It is
easy to add the data value, category name, and/or series name to the
chart using the Format Data Series options. However, I need to add data
from another area on the data sheet, which are the numbers representing
how many persons are currently in each grouping.

Data example:
HOURS NUMBERS
Group A Group B Group C Group A Group B
Group C
Nov 1 1000 750 500 10
7 3
Nov 7 1121 689 505 11
6 3

So the hours (1000, 750, 500) form a stack for each appropriate date
(with the total stack being total hours for that date) but in each
stacked range, is it possible to have the 10, 7, and 3 added to the
chart **without having to add a text box linked to each appropriate
cell**. Thusly the 10 whould appear in the 1000 hour stack, the 7 in
the 750, etc. When I tried the linked text box option, each time a new
data set is added, the Y axis scale MAY change if the hours range move
sufficiently, making it necessary to always readjust the text box
locations. Also every time new data is added, you have to create
another text box for each hours group - very tmmie consuming (as of
course my example here is only a very basic version of the more complex
actual chart.

Any thought appreciated, and thanks in advance.
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

I found my answer. It seams that an add-in is required. I am using the
XY Chart Labeler by appspro.com. It now does exactly what I was looking
for.


--
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

Mike -

If you only have one or two labels, you can add a datalabel using any of the
default options (value, label, series title), then use one of these
approaches:

(a) to make a static label, select the series of labels (one single click),
then the specific label (another single click), then click in the text of
the label and edit the text.

(b) to make a label linked to a cell, select the series of labels (one
single click), then the specific label (another single click), then click in
the formula bar, type the equals key, and click on the cell.

Rob Bovey's Chart Labeler automates (b) for a whole series at once.

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


"Mike M" wrote in
message ...

I found my answer. It seams that an add-in is required. I am using the
XY Chart Labeler by appspro.com. It now does exactly what I was looking
for.


--
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

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

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