|
Posted to microsoft.public.excel.charting
|
|
|
link colors to descriptions in bar charts
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
|