link colors to descriptions in bar charts

[mac]

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

 

[Jon Peltier]

You could plot them as separate series:

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

or adapt the last VBA procedure on this page:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=390

- Jon

 

[mac]

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]

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

 

[mac]

Thanx Jon

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
_______