The way to do it is to create a series to represent each category.
For example, supposing the values to be charted were
Name Amt
a 24
b 29
c 10
d 45
e 44
f 99
g 66
h 91
i 25
j 60
and you want values <=20 to be red, 21-50, blue and 50 green
in extra columns headed say Amt Red, Amt Green, Amt Blue, add formulae of
=IF(B2<=20,B2,NA())
=IF(AND(B220,B2<=50),B2,NA())
=IF(B250,B2,NA())
then build your chart with the source data coming fform columns A, C, D & E.
Then just format each series to your desired colour.
--
__________________________________
HTH
Bob
"Bus user" <Bus
wrote in message
...
I need to show the same basic data (in my case, journey times), but colour
coded or with labels to show different categories (in my eg, to show which
journeys can be extended to the City & which require a change of bus).
Childishly easy to conceptualise & surely not too difficult to do, but
how?