column chart

[Lynn]

i have the following columns
- dates
- no. of boxes packed
- no. of boxes to be packed.

how do i do a column chart which compares the no. of boxes packed vs
to be packed ?

 

[Michael.Tarnowski]

i have the following columns
- dates
- no. of boxes packed
- no. of boxes to be packed.

how do i do a column chart which compares the no. of boxes packed vs
to be packed ?

Hi Lynn,
maybe the site of Jon Peltier will give you some insights:
http://peltiertech.com/Excel/Charts/index.html

Have fun, cheers
Michael

 

[trip_to_tokyo]

Hi Lynn this is what you need to do in EXCEL 2007:-

1. I have set up the following file:-

c:\excel\resting_tue_aug_18_2009

2. A1 to A10:-

Dates
01/01/2009
02/01/2009
03/01/2009
04/01/2009
05/01/2009
06/01/2009
07/01/2009
08/01/2009
09/01/2009

3. B1 to B10:-

No Of Boxes Packed
1
2
3
4
5
6
7
8
9

4. C1 to C10:-

No Of Boxes To Be Packed
9
8
7
6
5
4
3
2
1

5. Highlight all of the above data (A1 to C10).

6. Insert / Charts / Colum / 2-D Column / Clustered Column

7. Chart will now launch.

8. This should give you what you want.

I can email you the above file if you want me to.