Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unique labels in each stacked bar?
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 "load/activity" 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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unique labels in each stacked bar?
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, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Dennis Mac" wrote in message ... 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 "load/activity" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get total value data labels in a stacked bar chart? | Charts and Charting in Excel | |||
Worksheet Column Labels ... Alphabet or Numeric ? | Excel Discussion (Misc queries) | |||
How do I have unique data labels for points in a XY Scatter plot? | Charts and Charting in Excel | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
Data labels on a stacked chart | Charts and Charting in Excel |