If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I combine a stacked bar chart with stacked colum chart? | Sin | Charts and Charting | 8 | December 20th, 2005 03:50 AM |
How do I permanently change the indent in labels? | BikeRNick | Page Layout | 6 | November 30th, 2005 02:07 PM |
Skips two labels when printing | FrogMan69 | Mailmerge | 1 | November 11th, 2005 07:47 AM |
center labels in x axis while skipping 3 of every 4 categories | HGood | Charts and Charting | 5 | August 26th, 2004 02:24 PM |
Count Unique Values | AHopper | Running & Setting Up Queries | 6 | May 26th, 2004 12:05 AM |