Put one Column behind another

[K.P.D]

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.

 

[ShaneDevenshire]

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.

 

[K.P.D]

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]

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.