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.