hello everyone
let's say i have a column chart that contains about 25 values and i want to
divide these values into 3 or 4 groups such that every group have a different
colour and pattern and a gap between itself and the next group, can i do this
without having to change the colour of every column?
thank u.

On Tue, 29 Apr 2008, in microsoft.public.excel.charting,
nada said:

hello everyone
let's say i have a column chart that contains about 25 values and i want to
divide these values into 3 or 4 groups such that every group have a different
colour and pattern and a gap between itself and the next group, can i do this
without having to change the colour of every column?
thank u.

Yes. Have three or four columns and place the values in the columns,
moving one column to the right occasionally as you go down the rows.

e.g. in the following two examples

A
1 1
2 2
3 3
4 4
5 5
6 6

A B
1 1
2 2
3 3
4 4
5 5
6 6

In the first example, they're all the same colour. In the second,
they're two colours.

Look at Jon Peltier's blog for examples of using a Pivot chart to
achieve the same effect.

http://peltiertech.com/WordPress/2008/04/23/
using-pivot-table-data-for-a-chart-with-a-dual-category-axis/

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.