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