| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Charts according to field heading
Hi I am trying to create a Macro which will fomat a stacked Column Chart
according to the column heading in the source data. I have five columns of data and I would like to assign a colorindex = 3 for the most severe, being red, and different colours for the rest according to the company spec. Can anyone help. cheers, Davie |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formatting Charts according to field heading
I blogged about this last week:
http://peltiertech.com/WordPress/200...y-series-name/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "davethewelder" wrote in message ... Hi I am trying to create a Macro which will fomat a stacked Column Chart according to the column heading in the source data. I have five columns of data and I would like to assign a colorindex = 3 for the most severe, being red, and different colours for the rest according to the company spec. Can anyone help. cheers, Davie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page Field on Pivot Charts | Charts and Charting in Excel | |||
| how can I exclude a heading but show that heading in sheet. | Excel Discussion (Misc queries) | |||
| In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
| Using Pivot Charts, how to hide field values in second level filters? | Excel Discussion (Misc queries) | |||
| Pivot Charts, hiding field values in second level filters? | Charts and Charting in Excel | |||
Linear Mode
