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

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

Thanx Jon but I need a word in a cell to be linked to a color on a chart. I
have about 2000 rows and 35 columns of data so i need to keep this as simple
as possible. Is there any simpler means of doing this.

"Jon Peltier" wrote:

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

If there were a simpler way, I'd have listed it first :)

If the data is that extensive and you don't want to mess with it on the main
sheet, you could use a second sheet, which has formulas that use the values
on the main sheet and the conditions that you specify to generate the source
data needed for a conditional chart like that in the first link. Or work
with the VBA solution in the second link.

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


"mac" wrote in message
...
Thanx Jon but I need a word in a cell to be linked to a color on a chart.
I
have about 2000 rows and 35 columns of data so i need to keep this as
simple
as possible. Is there any simpler means of doing this.

"Jon Peltier" wrote:

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

Thanx Jon

"Jon Peltier" wrote:

If there were a simpler way, I'd have listed it first :)

If the data is that extensive and you don't want to mess with it on the main
sheet, you could use a second sheet, which has formulas that use the values
on the main sheet and the conditions that you specify to generate the source
data needed for a conditional chart like that in the first link. Or work
with the VBA solution in the second link.

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


"mac" wrote in message
...
Thanx Jon but I need a word in a cell to be linked to a color on a chart.
I
have about 2000 rows and 35 columns of data so i need to keep this as
simple
as possible. Is there any simpler means of doing this.

"Jon Peltier" wrote:

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