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
Bookmarks