charts

[nada]

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.

 

[Del Cotter]

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/