Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Put one Column behind another
I would like to be able to make it so that the "Total" column for each
month's inspection be behind the "Pass" column so that I can show the pass/fail ammounts. This is the data I have: 3rd Q Jul-08 Jul-08 Aug-08 Aug-08 Sep-08 Sep-08 Insp. Total Pass Total Pass Total Pass Q 12 10 12 9 12 6 P 21 14 21 12 21 19 S 32 18 32 28 32 25 E 2 2 0 0 0 0 For example, Inspection Q had a total of 12 inspections performed, and 10 of those passed. If you place the Pass column in front of the total column you would be able to see the difference (2) overlapping. Is there a way to do this for all my data at once because I'm having a dificult time figuring it out. I'm using the 2007 Excel. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Put one Column behind another
Hi,
Select either series and choose Chart Tools, Format, Format Selection, on the Series Options tab drag the Series Overlap bar to 100 Overlapped. Click OK. If the wrong series is in from select a series if necessary and not the Formula Bar: =SERIES(,Sheet1!$C$2:$C$19,Sheet1!$D$2:$D$19,2) change the last number, here a 2, to 1. If it is 1 change it to 2 and press enter. -- Thanks, Shane Devenshire "K.P.D" wrote: I would like to be able to make it so that the "Total" column for each month's inspection be behind the "Pass" column so that I can show the pass/fail ammounts. This is the data I have: 3rd Q Jul-08 Jul-08 Aug-08 Aug-08 Sep-08 Sep-08 Insp. Total Pass Total Pass Total Pass Q 12 10 12 9 12 6 P 21 14 21 12 21 19 S 32 18 32 28 32 25 E 2 2 0 0 0 0 For example, Inspection Q had a total of 12 inspections performed, and 10 of those passed. If you place the Pass column in front of the total column you would be able to see the difference (2) overlapping. Is there a way to do this for all my data at once because I'm having a dificult time figuring it out. I'm using the 2007 Excel. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Put one Column behind another
When I change the Series Overlap bar to 100 to makes every series expand in
size as well as moving them all behind each other, even when I select just one. Right now this is what have; I'll submit the tables as well as a representation of the chart. Tables: Total 8-Jul 8-Aug 8-Sep Q 12 12 12 P 21 21 21 S 32 32 32 E 2 0 0 Passed 8-Jul 8-Aug 8-Sep Q 10 9 6 P 14 12 19 S 18 28 25 E 2 0 0 Chart: I have: -----|t|------------- ---|t|t|-------|p|--- -|t|t|t|-----|p|p|--- -|t|t|t|t|-|p|p|p|p|- I want: -----|t|----- ---|t|p|----- -|t|p|p|---- -|p|p|p|p|- I get: --|PPPPPPP|-- --|PPPPPPP|-- --|PPPPPPP|-- --|PPPPPPP|-- "ShaneDevenshire" wrote: Hi, Select either series and choose Chart Tools, Format, Format Selection, on the Series Options tab drag the Series Overlap bar to 100 Overlapped. Click OK. If the wrong series is in from select a series if necessary and not the Formula Bar: =SERIES(,Sheet1!$C$2:$C$19,Sheet1!$D$2:$D$19,2) change the last number, here a 2, to 1. If it is 1 change it to 2 and press enter. -- Thanks, Shane Devenshire "K.P.D" wrote: I would like to be able to make it so that the "Total" column for each month's inspection be behind the "Pass" column so that I can show the pass/fail ammounts. This is the data I have: 3rd Q Jul-08 Jul-08 Aug-08 Aug-08 Sep-08 Sep-08 Insp. Total Pass Total Pass Total Pass Q 12 10 12 9 12 6 P 21 14 21 12 21 19 S 32 18 32 28 32 25 E 2 2 0 0 0 0 For example, Inspection Q had a total of 12 inspections performed, and 10 of those passed. If you place the Pass column in front of the total column you would be able to see the difference (2) overlapping. Is there a way to do this for all my data at once because I'm having a dificult time figuring it out. I'm using the 2007 Excel. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Put one Column behind another
Hi,
Here is a start: 1. With your data set up like it is I picked the bottom set of data with titles and choose Insert, Column, Cluster Column. 2. select the top set of data with titles and press Ctrl C 3. select the chart and press Ctrl V 4. right click the 1st series on the chart and choose Format Data Series, on the first tab choose secondary axis and click close 5. right click the secondary axis and choose Format Axis, choose Maximum, Fixed, and enter 35, and click close (this number should agree with the max of the primary axis) 6. right click the 2nd series, which is now in the left most position and choose Format Data Series and click Secondary axis, Close 7. right click the 3rd series, which is now in the left most postion and choose Format Data Series and click Secondary axis, Close 8. right click the 4th series, which is now in the left most postion and choose Format Data Series and click Secondary axis, Close (with your data set this last one is a little hard to see) If this helps, please click the Yes button. -- Thanks, Shane Devenshire "K.P.D" wrote: When I change the Series Overlap bar to 100 to makes every series expand in size as well as moving them all behind each other, even when I select just one. Right now this is what have; I'll submit the tables as well as a representation of the chart. Tables: Total 8-Jul 8-Aug 8-Sep Q 12 12 12 P 21 21 21 S 32 32 32 E 2 0 0 Passed 8-Jul 8-Aug 8-Sep Q 10 9 6 P 14 12 19 S 18 28 25 E 2 0 0 Chart: I have: -----|t|------------- ---|t|t|-------|p|--- -|t|t|t|-----|p|p|--- -|t|t|t|t|-|p|p|p|p|- I want: -----|t|----- ---|t|p|----- -|t|p|p|---- -|p|p|p|p|- I get: --|PPPPPPP|-- --|PPPPPPP|-- --|PPPPPPP|-- --|PPPPPPP|-- "ShaneDevenshire" wrote: Hi, Select either series and choose Chart Tools, Format, Format Selection, on the Series Options tab drag the Series Overlap bar to 100 Overlapped. Click OK. If the wrong series is in from select a series if necessary and not the Formula Bar: =SERIES(,Sheet1!$C$2:$C$19,Sheet1!$D$2:$D$19,2) change the last number, here a 2, to 1. If it is 1 change it to 2 and press enter. -- Thanks, Shane Devenshire "K.P.D" wrote: I would like to be able to make it so that the "Total" column for each month's inspection be behind the "Pass" column so that I can show the pass/fail ammounts. This is the data I have: 3rd Q Jul-08 Jul-08 Aug-08 Aug-08 Sep-08 Sep-08 Insp. Total Pass Total Pass Total Pass Q 12 10 12 9 12 6 P 21 14 21 12 21 19 S 32 18 32 28 32 25 E 2 2 0 0 0 0 For example, Inspection Q had a total of 12 inspections performed, and 10 of those passed. If you place the Pass column in front of the total column you would be able to see the difference (2) overlapping. Is there a way to do this for all my data at once because I'm having a dificult time figuring it out. I'm using the 2007 Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
Divide Column A by Column B multiply Column C | Excel Worksheet Functions |