You could plot them as separate series:

http://peltiertech.com/Excel/Charts/...nalChart1.html

or adapt the last VBA procedure on this page:

http://pubs.logicalexpressions.com/P...cle.asp?ID=390

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


"mac" wrote in message
...
Is it posible to link a description in a data series represent a color in
a
bar chart. For expamle making the lollipops green and the bubblegum blue
in
the following data.
Lollipops 8 07/05/14
bubblegum 2 07/05/14
Lollipops 4 07/05/15
bubblegum 12 07/05/15
Lollipops 2 07/05/16
bubblegum 6 07/05/16