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