software

I think I found a charting limitation in Excel, but just looking for
confirmation.

I want to create a stacked bar chart to visualize a classic quot;load/activityquot;
chart used in Lean manufacturing. It would best to describe this with a
picture, but I cannot paste any graphics (sorry). Basically I would like the
persons name on the x axis, the Y axis is the total time for the stacked
bars. Each person will have 3 to 10 activities (bars) that will be stacked.
My question is with regards to labelling the activities. I would like to
have the labels of the various activities (e.g. A1, A2, A4 is person 1),
(A11, A13, A14, A20 is person 2), etc. Any thoughts?

Crude sample of stacked bar image with label (activity code and time):

_________________
| |
| |
| A4, 8 |
|________________|
| |
| A2, 4 |
|________________|
John

--
Thank you so much for your wisdom.

You can build your labels in worksheet cells, then use one of these free
utilities to apply these cells to the series in your chart.

Rob Bovey's Chart Labeler, appspro.com
John Walkenbach's Chart Tools, j-walk.com

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

quot;Dennis Macquot; gt; wrote in message
...
gt;I think I found a charting limitation in Excel, but just looking for
gt; confirmation.
gt;
gt; I want to create a stacked bar chart to visualize a classic
gt; quot;load/activityquot;
gt; chart used in Lean manufacturing. It would best to describe this with a
gt; picture, but I cannot paste any graphics (sorry). Basically I would like
gt; the
gt; persons name on the x axis, the Y axis is the total time for the stacked
gt; bars. Each person will have 3 to 10 activities (bars) that will be
gt; stacked.
gt; My question is with regards to labelling the activities. I would like to
gt; have the labels of the various activities (e.g. A1, A2, A4 is person 1),
gt; (A11, A13, A14, A20 is person 2), etc. Any thoughts?
gt;
gt; Crude sample of stacked bar image with label (activity code and time):
gt;
gt; _________________
gt; | |
gt; | |
gt; | A4, 8 |
gt; |________________|
gt; | |
gt; | A2, 4 |
gt; |________________|
gt; John
gt;
gt; --
gt; Thank you so much for your wisdom.