Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
customizing chart column color formats in code
papa jonah Mar 19, 9:48 am show options
Newsgroups: microsoft.public.excel From: "papa jonah" - Find messages by this author Date: 19 Mar 2005 09:48:30 -0800 Local: Sat, Mar 19 2005 9:48 am Subject: customizing chart column color formats in code Reply | Reply to Author | Forward | Print | Individual Message | Show original | Remove | Report Abuse I have some code that examines a set of data and generates a x1columncluster chart. Depending on the set of data, I may have any number of column clusters as a result. However, I currently format the columns manually to make certain groupings a given color and another group of columns a different color and so forth. I would like to automate this. Is there a way to go through each column like for x = 1 to numberOfColumns check group If group = 1 set color accordingly else set color differently end if Did that make sense? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry for duplicate posting
Sorry for the duplicate posting
"Papa Jonah" wrote: papa jonah Mar 19, 9:48 am show options Newsgroups: microsoft.public.excel From: "papa jonah" - Find messages by this author Date: 19 Mar 2005 09:48:30 -0800 Local: Sat, Mar 19 2005 9:48 am Subject: customizing chart column color formats in code Reply | Reply to Author | Forward | Print | Individual Message | Show original | Remove | Report Abuse I have some code that examines a set of data and generates a x1columncluster chart. Depending on the set of data, I may have any number of column clusters as a result. However, I currently format the columns manually to make certain groupings a given color and another group of columns a different color and so forth. I would like to automate this. Is there a way to go through each column like for x = 1 to numberOfColumns check group If group = 1 set color accordingly else set color differently end if Did that make sense? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customizing Color Palette in Excel 2007 | Excel Discussion (Misc queries) | |||
customizing text color | New Users to Excel | |||
Change column color in chart when column value is over/under goal | Charts and Charting in Excel | |||
Customizing a Pivot Chart | Charts and Charting in Excel | |||
Copy Color Formats Based On Column Date Values | Excel Discussion (Misc queries) |