Formatting of column charts

[confused]

Hi,
I have 2 fairly basic questions about chart formatting but Im a novice so
please bare with me!
1. have createda column chart through the pivot table option (the first
column chart availiable) How can I set the formatting so the columns have a
space between them rather than all being stuck together?
2. On the X axis I have "project name" and on the y axis I have "count of
actual items" and "count of expected items". At the moment, each project has
a different coloured bar and the bars are in 2 groups, one for "count of
actual items" the other for "count of expected items". How can I change it so
it is grouped by project, so it would show proj 1 and a bar for "actual" next
to a bar for "expected", then proj 2 with its bar for "actual and its bar for
"expected". I would want all the "actual" bars to be onj colour and all the
"expected" bars to be another colour.

thanks very much for any help anyone can give me
cheers

 

[Jon Peltier]

1. You mean separate the columns in a cluster? Double click any series, and on the
options tab, change the overlap to a negative number.

2. I'm not sure exactly what you're describing, but I have a couple suggestions.
a. Change by rows to by columns, or if the pivot chart doesn't let you do this,
switch the positions of the pivot fields from the row area to the column area, and
vice versa.
b. If the two pivot fields are in the same area, switch their positions so the one
further from the data area is moved closer.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[confused]

thankyou!!!

1. You mean separate the columns in a cluster? Double click any series, and on the
options tab, change the overlap to a negative number.

2. I'm not sure exactly what you're describing, but I have a couple suggestions.
a. Change by rows to by columns, or if the pivot chart doesn't let you do this,
switch the positions of the pivot fields from the row area to the column area, and
vice versa.
b. If the two pivot fields are in the same area, switch their positions so the one
further from the data area is moved closer.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______