chart with color automation
 

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

chart with color automation
 

Below are links to a couple of examples:

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

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

--
John Mansfield
http://cellmatrix.net





"Daniel" wrote:

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

chart with color automation
 

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


"John Mansfield" wrote:

Below are links to a couple of examples:

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

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

--
John Mansfield
http://cellmatrix.net





"Daniel" wrote:

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

chart with color automation
 

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


"John Mansfield" wrote:

Below are links to a couple of examples:

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

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

--
John Mansfield
http://cellmatrix.net





"Daniel" wrote:

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

chart with color automation
 

Perhaps easier than macros:

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

You are asking for conditional charts, not animated charts.

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


"Daniel" wrote in message
...
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