chart with color automation

[Daniel]

How can I create a bar chart with color according to an excel column
conditions. For example I have a graph with all salemen and in excel I have
a column which describe which products with the amount of sale column.
By look at the color I would know which product and the sale amount?
Thanks in advance
Daniel

 

[John Mansfield]

Below are links to a couple of examples:

http://www.cellmatrix.net/index.php/auto_color_chart_bars_version_1/

http://www.cellmatrix.net/index.php/auto_color_chart_bars_version_2/

 

[Daniel]

Hi John
The link asks to use macro and programming which I never did before. i
need an instruction with step by step, an easy way.
Thanks for your help.
Daniel

 

[Daniel]

Run this macro and it 's alway give me an error set object at
Set Pts = ActiveChart.SeriesCollection(1).Points(Cnt) ?
Daniel

 

[Jon Peltier]

Perhaps easier than macros:

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

You are asking for conditional charts, not animated charts.

- Jon