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
|
|||
|
|||
stacked column chart across multiple columns
Hi,
This is totally random, but I would like to know if the folowing would be possible: I have scrap and rework data from three assembly lines - A, B and C. Until now, I've been creating stacked column charts seperately one for each line. I would like to create one chart that includes information from all three lines - so for each X axis point, there would be three columns side by side, each of these representing an assembly line. But each of these columns need to be a stacked column containing scrap and rework info. This was only a suggestion by my supervisor, but all the same, I'd like to do it if possible. Do you think you can give me some directions? Thanks in advance, Joe. |
#2
|
|||
|
|||
stacked column chart across multiple columns
Hi Joe,
Have a look at Jon Peltier's page http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy Joe wrote: Hi, This is totally random, but I would like to know if the folowing would be possible: I have scrap and rework data from three assembly lines - A, B and C. Until now, I've been creating stacked column charts seperately one for each line. I would like to create one chart that includes information from all three lines - so for each X axis point, there would be three columns side by side, each of these representing an assembly line. But each of these columns need to be a stacked column containing scrap and rework info. This was only a suggestion by my supervisor, but all the same, I'd like to do it if possible. Do you think you can give me some directions? Thanks in advance, Joe. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
stacked column chart across multiple columns
Hi Andy,
Thanks a lot for the info. Now I have an additional problem: Following your instructions, on that North-S-E-W chart, I "hide" the information I dont want in there, right? Like the secondary X axis, the entry "series 1" in the legend, etc .. However, when I add the data table, it includes "Series 1". Is there a way to "hide" this from the data table? Thanks, Joe. |
#4
|
|||
|
|||
stacked column chart across multiple columns
Data tables display all series in the chart you can not remove selected
items. So you can either use 2 charts, one formated as cluster/stack the other unformatted but showing a data table. The position one chart over the other with an overlap so the data table appears. Or use formatted cells below the chartobject to represent the data table. Cheers Andy Joe wrote: Hi Andy, Thanks a lot for the info. Now I have an additional problem: Following your instructions, on that North-S-E-W chart, I "hide" the information I dont want in there, right? Like the secondary X axis, the entry "series 1" in the legend, etc .. However, when I add the data table, it includes "Series 1". Is there a way to "hide" this from the data table? Thanks, Joe. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create a chart that uses both columns and stacked column. | buske | Charts and Charting | 1 | January 25th, 2006 04:05 PM |
creating a bar graph | Johnfli | General Discussion | 0 | October 26th, 2005 08:16 PM |
Multiple Columns in a stacked column chart | Justin | Charts and Charting | 3 | April 23rd, 2004 12:15 PM |
Combined columnar chart(3 - 5 columns) and stacked column (1 column, 2 series) as one chart | wmcentee | Charts and Charting | 1 | April 8th, 2004 07:01 PM |
stacked column chart | Kelly McFaul | Charts and Charting | 1 | November 12th, 2003 03:48 AM |