| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart automation with entry data | Charts and Charting in Excel | |||
| Chart automation | Charts and Charting in Excel | |||
| Automation of Dynamic Chart Title and legend changes | Charts and Charting in Excel | |||
| Change color of bar graph w/automation | Charts and Charting in Excel | |||
| Chart Automation | Charts and Charting in Excel | |||
Hybrid Mode
